Issue with Multi-value Parameter "Reserved Value": Select All returns 0/False despite setting Custom Value to 'ALL'

Q&A
, ,
1

Hi all,

I explicitly configured my Multi-value Parameter with Set reserved value = Custom value: ‘ALL’.

The Issue: When I choose “Select All” in the control, it looks like QuickSight is passing NULL instead of the string 'ALL', ignoring my configuration.

I tested both scenarios in my Calculated Field:

  1. ifelse(in('ALL', ${pCategory}), ...) → Returns FALSE (Unexpected, since I set it to ‘ALL’).

  2. ifelse(in(NULL, ${pCategory}), ...) → Returns TRUE (Works!).

My Question: Why is QuickSight ignoring my “Custom Reserved Value” setting and passing NULL instead? Has anyone faced this behavior?

image
image566×915 35.9 KB

image
image209×387 7.28 KB

Select All leads to 0 value in visual
2

Hi @chanhlm,
Yes, using ‘NULL’ to account for your select all in multi value parameter scenarios is standard with how Quick Sight runs it’s calculations. To my understanding, when select all is chosen, it passes a ‘NULL’ value to the underlying parameter, therefore returning all values. So when building a calculated field to account for the multi-value, you’ll want to continue utilizing the ‘NULL’