Discussion Board for collaboration on QlikView Layout & Visualizations.
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,
Go to Solution.
Although this should be enough because WildMatch function is case insensitive
=If(WildMatch([CRM Case Title], '*Test*'), [CRM Case Title])
Try this instead
=If(WildMatch([CRM Case Title], '*TEST*', '*test*', '*Test*', '*testing*', '*TESTING*', '*Testing*'), [CRM Case Title])
Perfect!! Thank you so much for your help today :-)