# Multi Value Parameter not working when selecting All options

**URL:** <https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100>\
**Category:** Q&A\
**Tags:** error, developer, quick-sight\
**Created:** [November 30, 2023, 7:45pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100 "2023-11-30T19:45:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![EduardoMelo](https://avatars.discourse-cdn.com/v4/letter/e/8edcca/32.png) [@EduardoMelo](https://community.amazonquick.com/u/EduardoMelo)\
**Post date:** [November 30, 2023, 7:45pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/1 "2023-11-30T19:45:28Z")

</div>

Hi,

I have a multi-value parameter that I’m using to display fields in a graph. I’m using it in combination with the “in” function.  
something like:  
ifelse(in(‘Value 1’, $Multi-ValueParameter), Field1,NULL)  
My issue is, while it works when selecting multiple fields, once I select all the fields, none of them show up.

what should I pass to my calculated field in order to display the fields when all of them are selected?

Here’s what I thought:  
ifelse(in(‘Value 1’, $Multi-ValueParameter) OR in(‘ALL\_VALUES’, $Multi-ValueParameter), Field1,NULL)

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [December 1, 2023, 9:47am UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/2 "2023-12-01T09:47:37Z")

</div>

Hi @EduardoMelo  
could you check the following

```auto
ifelse(in(NULL, $Multi-ValueParameter), NULL , Field1)

```

---

<div class="post-metadata">

**Author:** ![EduardoMelo](https://avatars.discourse-cdn.com/v4/letter/e/8edcca/32.png) [@EduardoMelo](https://community.amazonquick.com/u/EduardoMelo)\
**Post date:** [December 1, 2023, 6:59pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/3 "2023-12-01T18:59:43Z")

</div>

Could work, but I don’t believe it’s applicable to this use case.  
Let me provide a bit more context, but thanks for the help so far.

I have a bar chart with multiple variables (5 in total). Each of the variables comes from calculated fields, following the logic I provided in my first message.  
As long as I don’t pick all of them at the same time, the logic works fine. If I select all five, though, the logic stops working and none of the variables show up in the chart.

Given it doesn’t work when I select all the options (variables) I thought I’d need something like this for every calculated field:

ifelse(in(‘Value 1’, $Multi-ValueParameter) OR in(‘ALL\_VALUES’, $Multi-ValueParameter), Field1,NULL)

Using your suggestion, I could end up showing a variable whenever any variable is picked, or am I wrong?

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [December 18, 2023, 11:59am UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/4 "2023-12-18T11:59:08Z")

</div>

Hi @EduardoMelo  
did you find a solution?  
BR

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [January 2, 2024, 5:34pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/5 "2024-01-02T17:34:52Z")

</div>

Hello @EduardoMelo !

Was @ErikG 's suggestion helpful, and if so could you mark their comment as a solution to help the community, or were you able to find a different solution?

It has been some time since we have heard from you but we would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived.

---

<div class="post-metadata">

**Author:** ![EduardoMelo](https://avatars.discourse-cdn.com/v4/letter/e/8edcca/32.png) [@EduardoMelo](https://community.amazonquick.com/u/EduardoMelo)\
**Post date:** [January 2, 2024, 6:01pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/6 "2024-01-02T18:01:26Z")

</div>

It did. It worked. Thanks @ErikG!

---

<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:** [January 2, 2024, 7:17pm UTC](https://community.amazonquick.com/t/multi-value-parameter-not-working-when-selecting-all-options/22100/7 "2024-01-02T19:17:52Z")

</div>

Thats great! I’ve marked Eriks post as a solution.
