# Select All leads to 0 value in visual

**URL:** <https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392>\
**Category:** Q&A\
**Tags:** parameters, Business-Intelligence-Engineer\
**Created:** [February 3, 2026, 4:41pm UTC](https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392 "2026-02-03T16:41:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alisha.kumar.c](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@alisha.kumar.c](https://community.amazonquick.com/u/alisha.kumar.c)\
**Post date:** [February 3, 2026, 4:41pm UTC](https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392/1 "2026-02-03T16:41:40Z")

</div>

I am using a multiselect parameter in a calculative field, upon adding the paramter as a control and clicking on ‘Select All’ the values in the visual become 0. The formula I am using is “ifelse({parent\_name}=${Clientname} AND in({client\_name}, ${pMultiChildName}),leads,0)”

---

<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:** [February 3, 2026, 9:42pm UTC](https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392/2 "2026-02-03T21:42:31Z")

</div>

Hi @alisha.kumar.c and welcome to the Quick Community!  
Quick Sight has some odd behavior that when ‘select all’ is selected, the parameter reads as ‘NULL’. Therefore you will need to account for null value as well in your formula. Take a look at the previous post shared below that covers a similar scenario. Let me know if this works for your case or if you have any additional questions!

[https://community.amazonquick.com/t/issue-with-multi-value-parameter-reserved-value-select-all-returns-0-false-despite-setting-custom-value-to-all/51](https://community.amazonquick.com/t/issue-with-multi-value-parameter-reserved-value-select-all-returns-0-false-despite-setting-custom-value-to-all/51)

---

<div class="post-metadata">

**Author:** ![alisha.kumar.c](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@alisha.kumar.c](https://community.amazonquick.com/u/alisha.kumar.c)\
**Post date:** [February 5, 2026, 8:32am UTC](https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392/3 "2026-02-05T08:32:47Z")

</div>

Hi @Brett ,  
Thank you for sharing the link.  
I was able to use a formula to include ‘select all’ scenario using the in() function and it worked.

---

<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:** [February 5, 2026, 4:19pm UTC](https://community.amazonquick.com/t/select-all-leads-to-0-value-in-visual/51392/4 "2026-02-05T16:19:55Z")

</div>

Glad to hear that worked well for your case!