# Comma Separated Values Filter

**URL:** <https://community.amazonquick.com/t/comma-separated-values-filter/6378>\
**Category:** Q&A\
**Tags:** filters, quick-sight\
**Created:** [September 28, 2022, 7:00pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378 "2022-09-28T19:00:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaking](https://avatars.discourse-cdn.com/v4/letter/c/dfb087/32.png) [@chaking](https://community.amazonquick.com/u/chaking)\
**Post date:** [September 28, 2022, 7:00pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378/1 "2022-09-28T19:00:03Z")

</div>

Hi,  
We have a column with comma separated values that we’d like to have a filter on. The filter would list all distinct values from the column (we could also manually build the filter list if needed) and allow for multi-select. It should then evaluate the csv in each row to see if there’s a match to any of the selected filter values.

Currently QS doesn’t support multi-select parameters in calculated fields, which is the main blocker we think.

Outside of creating a new row for each value in the csv column, is there a workaround for this?

E.g. the values “AA, AB, AC, AD, AE” are contained in a column. The filter should list all of those values and allow for selection of multiple values. Then we’d like to find all rows where any of the selected filter values exist in the column.

---

<div class="post-metadata">

**Author:** ![Koushik\_Muthanna](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/koushik_muthanna/32/3290_2.png) [@Koushik\_Muthanna](https://community.amazonquick.com/u/Koushik_Muthanna)\
**Post date:** [September 30, 2022, 2:08pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378/2 "2022-09-30T14:08:34Z")

</div>

Hi,

I think your question is similar to the following : [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)

---

<div class="post-metadata">

**Author:** ![Karthik\_Tharmarajan](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/karthik_tharmarajan/32/3282_2.png) [@Karthik\_Tharmarajan](https://community.amazonquick.com/u/Karthik_Tharmarajan)\
**Post date:** [October 4, 2022, 8:40pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378/3 "2022-10-04T20:40:29Z")

</div>

Hi @chaking, We hope link provided by Koushik worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.” Thanks!

Regards,  
Karthik

---

<div class="post-metadata">

**Author:** ![chaking](https://avatars.discourse-cdn.com/v4/letter/c/dfb087/32.png) [@chaking](https://community.amazonquick.com/u/chaking)\
**Post date:** [January 6, 2023, 4:20pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378/4 "2023-01-06T16:20:39Z")

</div>

Appreciate the workaround, however we have chosen to not use it as it’s a non-standard filter experience and we have a large set of possible values that would make usage difficult.

---

<div class="post-metadata">

**Author:** ![ahhhle](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@ahhhle](https://community.amazonquick.com/u/ahhhle)\
**Post date:** [February 23, 2023, 12:23pm UTC](https://community.amazonquick.com/t/comma-separated-values-filter/6378/5 "2023-02-23T12:23:07Z")

</div>

Hi @chaking, did you manage to find some alternative solution?