# Parameter for Calculated field

**URL:** <https://community.amazonquick.com/t/parameter-for-calculated-field/21694>\
**Category:** Q&A\
**Tags:** parameters, analysis, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 23, 2023, 6:27pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694 "2023-11-23T18:27:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nsaleh](https://avatars.discourse-cdn.com/v4/letter/n/71c47a/32.png) [@nsaleh](https://community.amazonquick.com/u/nsaleh)\
**Post date:** [November 23, 2023, 6:27pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694/1 "2023-11-23T18:27:00Z")

</div>

I have a calculated field that concatenate ID & ID description. I want to use this calculated field as a parameter with a control that links to this calculated field. Please help. Thanks

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [November 23, 2023, 11:12pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694/2 "2023-11-23T23:12:15Z")

</div>

Hi @nsaleh  
Please check out

> **[Using QuickSight parameters and controls to drive interactivity in your...](https://aws.amazon.com/de/blogs/big-data/using-quicksight-parameters-and-controls-to-drive-interactivity-in-your-dashboards/)**
>
> Amazon QuickSight added support for parameters, on-screen controls, and URL actions earlier this year. In this blog post, we walk through several examples to show how you can use these capabilities within interactive dashboards for your audience.

BR

---

<div class="post-metadata">

**Author:** ![nsaleh](https://avatars.discourse-cdn.com/v4/letter/n/71c47a/32.png) [@nsaleh](https://community.amazonquick.com/u/nsaleh)\
**Post date:** [November 24, 2023, 3:16pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694/3 "2023-11-24T15:16:57Z")

</div>

Hi Eric,

Thanks for the link. I tried the method on this link before (I link to a specific value, and I create the ifelse statement); however, the selection I get at the end is just between the names of the ID NO and ID description and no link to the dataset itself.  
My end result is to select data from the parameter, ie. select 100 from the ID no, or instead of typing a #, I type the description (from data of ID description) and my data changes accordingly. same as the concatenate, but I need this concatenated fields to be one parameter that affects all the sheets on my analysis.

---

<div class="post-metadata">

**Author:** ![abacon](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/abacon/32/2291_2.png) [@abacon](https://community.amazonquick.com/u/abacon)\
**Post date:** [November 28, 2023, 12:27pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694/4 "2023-11-28T12:27:42Z")

</div>

Hi @nsaleh,

I created a [calculated field](https://docs.aws.amazon.com/quicksight/latest/user/adding-a-calculated-field-analysis.html) which concatenates the ID and ID description as follows:

**Concatenated ID string**  
`concat(toString({ID})," ", {ID decription})`

Then built an analysis, adding a “String” parameter, an associated “Text field” control and a [“Custom Filter” with a “Contains” condition that uses the parameter](https://docs.aws.amazon.com/quicksight/latest/user/parameters-filtering-by.html):  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/7/7cbcf4171caf12f2ee4ffe8ab5f24e5ab32de975.png)

You can then add the same filter to each sheet in the analysis.

Does this help meet your requirement?

Many Thanks,  
Andrew

---

<div class="post-metadata">

**Author:** ![nsaleh](https://avatars.discourse-cdn.com/v4/letter/n/71c47a/32.png) [@nsaleh](https://community.amazonquick.com/u/nsaleh)\
**Post date:** [November 28, 2023, 5:22pm UTC](https://community.amazonquick.com/t/parameter-for-calculated-field/21694/5 "2023-11-28T17:22:20Z")

</div>

> [@abacon](#):
>
> oncat(toString({ID})," ", {ID decription})

Hi Andrew, thanks for the information, very helpful