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. …

you can use in. in - Amazon QuickSight Use the in function for calculated fields in Amazon QuickSight. ifelse(in(NULL,${Paramater}),“XYZ”,“None”)

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

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

ALL In Parameter

Q&A

Max June 9, 2023, 3:01pm 4

you can use in.

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

Level Aggregate Functions and Order of calculations

Topic		Replies	Views
Calculated field for the “Select All” with Quick Sight filter control Q&A quick-sight , filters-controls-and-parameters , calculations	2	2323	June 27, 2023
Using multivalue parameter with select all in a calculated field Q&A analysis , feature-request , quick-sight , calculations	4	1889	June 19, 2023
IN function Q&A parameters , error , quick-sight , calculations , Business-Intelligence-Engineer	1	173	June 5, 2024
"Select All" in parameter leads to blank values in chart Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	514	July 2, 2024
Multi Value Parameter not working when selecting All options Q&A developer , error , quick-sight	6	377	January 2, 2024

ALL In Parameter

Related topics