ALL In Parameter

Question & Answer
1

I have a string Parameter, and I am trying to Write a calculation where if a User selects All in the parameter, then some Random Text Should be visible.

Is this possible in quicksight.

Example:
Ifelse(parameter =“All”,“XYZ”,“None”)

I tried using “ALL_VALUES” but not sure how exactly this works.

2

Use isNull

ifelse(isNull(${Param}),'xyz','none')
3

Hey Max,
I have multi value parameter, upon trying your calculation I got the following error:

*Expression ifelse(isNull($Paramater}),“XYZ”,“None”) for function IS NULL has incorrect argument type String List IS NULL

4

you can use in.

ifelse(in(NULL,${Paramater}),“XYZ”,“None”)
1 Like