# Creating dynamic parameter with many variables **URL:** \ **Category:** Q&A\ **Tags:** calculations, quick-sight\ **Created:** [January 11, 2023, 4:34pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983 "2023-01-11T16:34:38Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 11, 2023, 4:34pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/1 "2023-01-11T16:34:38Z")
I have tried many times but unfortunately cannot create dynamic parameter. I have data like this d**atetime sensor1 (str) variables (# ): aa1, bb1, cc1 sensor2(str) variables(#): aa2, bb2, cc2** I want to create parameter /control so that the sensors and the variable can be selected using control. Any hint how to do that. ---
**Author:** ![rajjaya](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/rajjaya/32/4534_2.png) [@rajjaya](https://community.amazonquick.com/u/rajjaya)\ **Post date:** [January 12, 2023, 7:28am UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/2 "2023-01-12T07:28:27Z")
Hi @rkhan Are you looking to create a parameter control with each value looking similar to the following? aa1, bb1, cc1 aa2, bb2, cc2 One option is to create a calculated field at the data set level using [concat()](https://docs.aws.amazon.com/quicksight/latest/user/concat-function.html), and join the variables (after converting them to string). You can then create a control using this new field. Another option is using [cascading controls](https://docs.aws.amazon.com/quicksight/latest/user/parameters-controls.html). You can create individual control for each variable and based on the value selected in the parent coltrol, child controls show only relevant values. When creating cascading controls, the following limitations apply. ``` Cascading controls must be tied to dataset columns from the same dataset. The child control must be a dropdown or list control. For parameter controls, the child control must be linked to a dataset column. For filter controls, the child control must be linked to a filter (instead of showing only specific values). The parent control must be one of the following. A string, integer, or numeric parameter control. A string filter control (EXCLUDING Top-Bottom filters). A non-aggregated numeric filter control. A date filter control (EXCLUDING Top-Bottom filters). ``` Best, Raj ---
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 13, 2023, 4:17pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/3 "2023-01-13T16:17:01Z")
Thank you for the reply. I already knew that might not understand correctly. If I convert int data to str, can you explain how can I create controls like:(variable are int types, sensors are str. The bad thing is the whole sensors col rows are filled with sensor1 or sensor 2 ) sensor control: sensor 1 sensor2 variable control: aa1 aa2 bb1 bb2 I know it can be done using field wells but I want to do on analysis ---
**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\ **Post date:** [January 17, 2023, 4:20pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/4 "2023-01-17T16:20:27Z")
Hi @rkhan! You can move filter controls from the field wells to the analysis sheet. ![move_to_sheet](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b58c7078f3d3e64774b29c4fc513625a555ff56e.jpeg) ---
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 18, 2023, 11:32pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/5 "2023-01-18T23:32:06Z")
Can you show how you did? ---
**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\ **Post date:** [January 19, 2023, 2:50pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/6 "2023-01-19T14:50:23Z")
Hi @rkhan! Here is the [link](https://docs.aws.amazon.com/quicksight/latest/user/filter-controls.html) to the doc with examples on how to add filter controls to the dashboard sheet or to the field wells. Best Regards, Kellie ---
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 19, 2023, 5:20pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/7 "2023-01-19T17:20:56Z")
Hi, I tried using it. The issue is I have many int columns and few string. type. I want to know how to group? ---
**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\ **Post date:** [January 20, 2023, 8:41pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/8 "2023-01-20T20:41:03Z")
Hi @rkhan! I’m not sure what you mean by group. You want to group values within a field or across fields? Could you please share a sample of the data so I can better understand and provide a solution? Thanks, Kellie ---
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 21, 2023, 4:58pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/9 "2023-01-21T16:58:20Z")
Thank you I have the following data. The Gateway1 col. fills with the same valuesi.e., G1\_M1. And there are 10 Gateways ways and each has these shown variables (int, decimals) -more than 10 as well. I want to create controls that select the gateways first and then a variable from a list ![Screenshot_20230117_071631](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/d318ac1e7d91d643eb762a194717d0d669d65893.png) ---
**Author:** ![AnwarAli](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/anwarali/32/3152_2.png) [@AnwarAli](https://community.amazonquick.com/u/AnwarAli)\ **Post date:** [January 22, 2023, 9:05am UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/10 "2023-01-22T09:05:02Z")
Hi RKhan, Have you tried using cascaded filter with outer filter value as “string-single-value-parameter” for sensor and inner filter value as “int-multi-value-parameter” for variable as shown below: ![Cascade_filter_2](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/d6ef2191b9d52d4deeddb064e620113c188c03fc.gif) ---
**Author:** ![rkhan](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@rkhan](https://community.amazonquick.com/u/rkhan)\ **Post date:** [January 23, 2023, 12:58pm UTC](https://community.amazonquick.com/t/creating-dynamic-parameter-with-many-variables/8983/11 "2023-01-23T12:58:44Z")
Thank you @AnwarAli for this demonstration. I wasnot doing something right.I havent tried this solution but i would definitely try. Also thanks @Kellie_Burton @rajjaya for the help as well.