# User enters a list of comma separated values as Filter Selection

**URL:** <https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225>\
**Category:** Q&A\
**Tags:** analysis, filters, quick-sight\
**Created:** [April 13, 2023, 11:35pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225 "2023-04-13T23:35:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![NeerajGautam](https://avatars.discourse-cdn.com/v4/letter/n/e495f1/32.png) [@NeerajGautam](https://community.amazonquick.com/u/NeerajGautam)\
**Post date:** [April 13, 2023, 11:35pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/1 "2023-04-13T23:35:54Z")

</div>

Hi,

Does quicksight support a functionality where a user can enter a comma separated list of values as Filter selection which can then be passed on as a WHERE caluse to the query. Say user wants to enter v1,v2,v3 as multiple values of the single filter and then query should look like

```auto
select * from myTable where col1 in (v1,v2,v3);

```

Another extension of functionality that I would like to achieve is remove any extra spaces in these comma separated values if present. For example if user enters `v1 , v2 , v3` then it should treat the values as `v1,v2,v3`

Any help is appreciated

---

<div class="post-metadata">

**Author:** ![apjvinod](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@apjvinod](https://community.amazonquick.com/u/apjvinod)\
**Post date:** [April 14, 2023, 9:42am UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/2 "2023-04-14T09:42:46Z")

</div>

Hi @NeerajGautam

Could you please check this post , i think this should help you : [How to use values from a list aggregated field in a table to a filter in Quicksight?](https://community.amazonquick.com/t/how-to-use-values-from-a-list-aggregated-field-in-a-table-to-a-filter-in-quicksight/4717)

Thanks  
VInod

---

<div class="post-metadata">

**Author:** ![NeerajGautam](https://avatars.discourse-cdn.com/v4/letter/n/e495f1/32.png) [@NeerajGautam](https://community.amazonquick.com/u/NeerajGautam)\
**Post date:** [April 14, 2023, 5:18pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/3 "2023-04-14T17:18:31Z")

</div>

Hi @apjvinod ,

Thanks for looking into it. I think my requirement is little different from the post you mentioned. I don’t need to exclude any values or don’t have a dataset where a column has a concatenated list of values.

What I am looking for is if Quicksight has a feature to allow users to enter Comma Separated Values which can then be used as a filter in my SQL query to the database?

---

<div class="post-metadata">

**Author:** ![David\_Wong](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/david_wong/32/15630_2.png) [@David\_Wong](https://community.amazonquick.com/u/David_Wong)\
**Post date:** [April 14, 2023, 5:30pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/4 "2023-04-14T17:30:24Z")

</div>

Format your control and select “Text field - multiline”. You can then select “Comma” as your separator. It looks like you can only do this if you use a parameter for your filter.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/ba680b5256dd46371e8fc567683f28e71730deee.png)

---

<div class="post-metadata">

**Author:** ![Asem](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/asem/32/3363_2.png) [@Asem](https://community.amazonquick.com/u/Asem)\
**Post date:** [April 19, 2023, 10:06pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/5 "2023-04-19T22:06:38Z")

</div>

Hi,  
Did Davids comment help with your scenario? I’m marking it as a solution but please feel free to let us know in case you need additional assistance.  
Thanks

---

<div class="post-metadata">

**Author:** ![NeerajGautam](https://avatars.discourse-cdn.com/v4/letter/n/e495f1/32.png) [@NeerajGautam](https://community.amazonquick.com/u/NeerajGautam)\
**Post date:** [April 20, 2023, 9:28pm UTC](https://community.amazonquick.com/t/user-enters-a-list-of-comma-separated-values-as-filter-selection/12225/6 "2023-04-20T21:28:00Z")

</div>

Hi Asem,

I am yet to try it out. I will update the thread some time next week.