Hello All, I am attempting to filter my analysis based on a Parameter string list, and map it to different fields in a row of a table. I am attempting to create a filter for multiple items based on an id without duplicating rows. I saw that using multi-select parameters in calculated fields was not …

How to check if a string is in a string list using calculated fields?

Giridhar.Prabhu November 22, 2024, 4:35am 2

You are right. The IN is what you use to find a value in a String List. I attended a learning session yesteday that covers a pretty useful and practical example using multi-value parameters.

I have provided the link below to the video. Hope it helps you get your calculation working.

Regards,
Giri

Topic		Replies	Views
What function can determine whether each row of my string filed is one of values defined in a String List Q&A parameters , quick-sight , calculations , Business-Intelligence-Engineer	1	205	March 30, 2024
Calculated Field error list = string Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	5	591	August 7, 2024
In a quicksight calculated field how to check whether a string contains 1 or more values from a multivalue parameter? Q&A feature-request , quick-sight , filters-controls-and-parameters , calculations , how-to , Business-Intelligence-Engineer	3	1530	September 25, 2023
How to search a string in a list using ifelse in aws QUICKSIGHT Q&A parameters , quick-sight , calculations , how-to	4	3122	March 30, 2023
Using multivalue parameter with select all in a calculated field Q&A analysis , feature-request , quick-sight , calculations , how-to	5	1699	June 19, 2023

How to check if a string is in a string list using calculated fields?

Related topics