I have a parameter “pDimension” which is of String datatype and ‘Multi values’. The values (Specific values) it contains are dim1 dim2 dim3 I have a control (Control options: list) in my report showing all these values listed - dim1 dim2 dim3 I need to create a calculated field in one datas…

Hi @Aniruddha_Sinha , You can use a formula of the following style in the calculated field to achieve what you’ve described (simply replace the static “true” and “false” values with your desired logic): ifelse(in("dim1",${pDimension}),"true","false") Furthermore, I’d recommend to hide the Select a…

How to search a string in a list using ifelse in aws QUICKSIGHT

Q&A

Sanjeeb2022 March 29, 2023, 4:35pm 3

Thank you @Thomas for sharing this solution, very detailed.

Regards - San

1 Like

How to hide a table column based on multi-value action filter selection

Topic		Replies	Views
Calculated Field error list = string Q&A error , calculations , Business-Intelligence-Engineer	5	605	August 7, 2024
Ifelse Calculated Field with Parameter Q&A error , calculations	4	2101	March 17, 2023
Calculated field based on multi select parameter Q&A Business-Intelligence-Engineer	4	63	October 28, 2025
How to check if a string is in a string list using calculated fields? Q&A filters , calculations , Business-Intelligence-Engineer	3	77	December 6, 2024
Unknown syntax error in calculated field Q&A developer , error	12	92	April 4, 2025

How to search a string in a list using ifelse in aws QUICKSIGHT

Related topics