Calculate a column of true/false based on multi-value parameter

[amico]

Hi,
I’m looking for a function a which checks if a string column c1 contains substrings apeearing in a multi-value parameter p2. For example if my p2 parameter contanis 2 values, ‘amreica’ and ‘ball’ and my c1 column contains 4 values of ‘amreica x’, ‘sky ball’, ‘basket ball’ and ‘f-side’, only rows with ‘amreica x’, ‘sky ball’, ‘basket ball’ values will get true. ‘f-side’ will get false.
Any ideas?

[Giridhar.Prabhu]

Hi @amico

See if the following post helps you. Basically you have to use the IN function for your search and also include a case where the Select All is selected in the parameter (see the note from @ErikG in the post)

Multi Value Parameter not working when selecting All options

Hi, I have a multi-value parameter that I’m using to display fields in a graph. I’m using it in combination with the “in” function. something like: ifelse(in(‘Value 1’, $Multi-ValueParameter), Field1,NULL) My issue is, while it works when selecting multiple fields, once I select all the fields, none of them show up. what should I pass to my calculated field in order to display the fields when all of them are selected? Here’s what I thought: ifelse(in(‘Value 1’, $Multi-ValueParameter) OR i…

[Brett]

Hi @amico,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @amico,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you