# Find the set of values

**URL:** <https://community.amazonquick.com/t/find-the-set-of-values/37283>\
**Category:** Q&A\
**Tags:** analysis, filters, Business-Intelligence-Engineer, quick-sight\
**Created:** [October 22, 2024, 6:22am UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283 "2024-10-22T06:22:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![weird\_guy](https://avatars.discourse-cdn.com/v4/letter/w/43a26b/32.png) [@weird\_guy](https://community.amazonquick.com/u/weird_guy)\
**Post date:** [October 22, 2024, 6:22am UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283/1 "2024-10-22T06:22:05Z")

</div>

Hello.

I really need you help to highlight the set of unique values from exact field. But Ive faced with Quick Sight limitation in custom filet list (actually I have the list with more than 500000 values)

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/5/45c837a0db2b298f73c0279edf270f4aee3e42f4.png)

Could you provide another solution to the problem please?

Thank you.

---

<div class="post-metadata">

**Author:** ![royyung](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/royyung/32/3302_2.png) [@royyung](https://community.amazonquick.com/u/royyung)\
**Post date:** [October 22, 2024, 2:33pm UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283/2 "2024-10-22T14:33:46Z")

</div>

instead of using order\_id, do you have any criteria or indicator in the data source to filter the list?  
you can create a calculated field as an indicator (e.g. Y or N) in the dataset or analysis and use a ifElse condition to define of the value of the calculated field. then use this calculated filed to filter the data

> **[Ifelse - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/ifelse-function.html)**
>
> Use the ifelse function for calculated fields in Amazon QuickSight.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [October 22, 2024, 4:28pm UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283/3 "2024-10-22T16:28:06Z")

</div>

Hi @weird_guy,  
Another thing you could consider is to create a parameter for Order ID and then add a control for it.

- If you use the ‘dropdown’ option, since your list has so many values, it will just provide you with a text box (which you can input the exact field you’d like).
- If you need to setup a filter regarding that order ID. You can then link your filter to your parameter so that it will filter to your exact field you’ve set in the control.

Let us know if you have any additional questions!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 5, 2024, 11:05pm UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283/4 "2024-11-05T23:05:31Z")

</div>

Hi @weird_guy,  
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 8, 2024, 7:48pm UTC](https://community.amazonquick.com/t/find-the-set-of-values/37283/5 "2024-11-08T19:48:37Z")

</div>

Hi @weird_guy,  
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.

Thank you!