Select All leads to 0 value in visual

Q&A
,
1

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)”

2

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.amazonquicksight.com/t/issue-with-multi-value-parameter-reserved-value-select-all-returns-0-false-despite-setting-custom-value-to-all/51

2 Likes
3

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.

1 Like
4

Glad to hear that worked well for your case!