Hi @olddog,
The reserved value ‘ALL_VALUES’ is used for internal purposes only currently and is not available for cross checking in calculations.
The parameter can have one of two values in the ‘select all’ state.
When analysis/dashboard is loaded, the parameter is set with the default value as configured.
If that default value happens to include all the options in the parameter control, the ‘select all’ option there in (if set to be visible) will show up in checked state.
Then, as you change the selections and eventually return to ‘select all’ state (either by selecting the ‘select all’ explicitly or by selecting all the individual options), the parameter gets a NULL value.
So, when looking for ‘select all’ state from calculations, you should look for the full value set (if that is being set as default) as well as NULL value.
Like wise, when checking multi select parameters to see if a specific value is selected, you should check for that specific value as well as NULL value (to cover ‘select all’ state)
For multi value parameters, you can do the NULL check using
in(NULL, ${MultiValParam})
and for single value parameters, you can do it using
isNull(${SingleValParam})
I know this is not intuitive and have requested for a doc update to make this more discoverable.
This should help you fix your calculation and hence I’m marking this as solution for now.
If you still face issues, please post a sample using Arena and we can have another look at your specific calculation.
Regards,
Arun Santhosh
Pr QuickSight SA