# Set calculated filed from Dropdown Multiselect

**URL:** <https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689>\
**Category:** Q&A\
**Tags:** feature-request, quick-sight\
**Created:** [April 25, 2023, 3:22pm UTC](https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689 "2023-04-25T15:22:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gborasio](https://avatars.discourse-cdn.com/v4/letter/g/85e7bf/32.png) [@gborasio](https://community.amazonquick.com/u/gborasio)\
**Post date:** [April 25, 2023, 3:22pm UTC](https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689/1 "2023-04-25T15:22:38Z")

</div>

Hi all i want to use calculated filed to show/hide columns based on some value from a dropdown- multiselect menu.  
Example i have column A and B and want to select A or B or A And B and assign value to a calculated field in order to show some column or not. How can i set ifelse command in case of multiselet?

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [April 25, 2023, 4:12pm UTC](https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689/2 "2023-04-25T16:12:13Z")

</div>

This is currently not possible.

You might look to do this with a parameter and load different visuals.

> **[Conditional rules - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/conditional-rules.html)**
>
> Use conditional rules in Amazon QuickSight.

---

<div class="post-metadata">

**Author:** ![cmruiter](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/cmruiter/32/7059_2.png) [@cmruiter](https://community.amazonquick.com/u/cmruiter)\
**Post date:** [April 28, 2023, 7:35pm UTC](https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689/3 "2023-04-28T19:35:46Z")

</div>

At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have marked this as a feature request.

I hope @Max 's suggestion provides you with a potential workaround in the interim.

---

<div class="post-metadata">

**Author:** ![cmruiter](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/cmruiter/32/7059_2.png) [@cmruiter](https://community.amazonquick.com/u/cmruiter)\
**Post date:** [April 28, 2023, 7:35pm UTC](https://community.amazonquick.com/t/set-calculated-filed-from-dropdown-multiselect/12689/4 "2023-04-28T19:35:59Z")

</div>

Archived on April 28, 2023, 7:35pm UTC