Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creating a dimension to select a list of values

Hello,

I used this formula to select all the values of my field 'CRM Case Title' that containg the word "test" written in all possible ways

=If([CRM Case Title] like ("*TEST*","*test*","*Test*","*testing*","*TESTING*","*Testing*"),[CRM Case Title])


This is what I entered when creating a dimension, but for some reason I got error in my expression,

Could you please help me see what is wrong with my expression?

Thank you so much,

1 Solution

Accepted Solutions
sunny_talwar

Although this should be enough because WildMatch function is case insensitive

=If(WildMatch([CRM Case Title], '*Test*'), [CRM Case Title])

View solution in original post

3 Replies
sunny_talwar

Try this instead

=If(WildMatch([CRM Case Title], '*TEST*', '*test*', '*Test*', '*testing*', '*TESTING*', '*Testing*'), [CRM Case Title])

sunny_talwar

Although this should be enough because WildMatch function is case insensitive

=If(WildMatch([CRM Case Title], '*Test*'), [CRM Case Title])

Anonymous
Not applicable
Author

Perfect!! Thank you so much for your help today 🙂