# Using delimiter separated field as filter

**URL:** <https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793>\
**Category:** Q&A\
**Tags:** parameters, filters, quick-sight\
**Created:** [April 27, 2023, 12:57pm UTC](https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793 "2023-04-27T12:57:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raghu](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@Raghu](https://community.amazonquick.com/u/Raghu)\
**Post date:** [April 27, 2023, 12:57pm UTC](https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793/1 "2023-04-27T12:57:17Z")

</div>

Greetings,  
In my product, I am collecting data using multiselect and the data is being stored in a field using comma as separator. Now I want to use this field as a filter so that the user can see statistics for rows that have at least one selected value. Is there any way I can do this.  
Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [April 27, 2023, 1:23pm UTC](https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793/2 "2023-04-27T13:23:12Z")

</div>

Hi @Raghu ,

You can achieve this by creating parameter in Quick Sight and use the same parameter control as a filter. Put your default parameter value so that it always so you default filter value.

Thanks & Regards  
Biswajit Dash

---

<div class="post-metadata">

**Author:** ![Raghu](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@Raghu](https://community.amazonquick.com/u/Raghu)\
**Post date:** [April 28, 2023, 11:09am UTC](https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793/3 "2023-04-28T11:09:07Z")

</div>

@Biswajit_1993 Is it possible to convert those comma separated values into array using calculated field?

---

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [May 4, 2023, 12:43pm UTC](https://community.amazonquick.com/t/using-delimiter-separated-field-as-filter/12793/4 "2023-05-04T12:43:40Z")

</div>

Hi @Raghu yes you can do that by using split() in Quick Sight.

Thanks & Regards  
Biswajit Dash