Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nelrhaffouli
Contributor
Contributor

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])

View solution in original post

nelrhaffouli
Contributor
Contributor
Author

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