Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nelrhaffouli
New 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

Re: Creating a dimension to select a list of values

Although this should be enough because WildMatch function is case insensitive

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

3 Replies

Re: Creating a dimension to select a list of values

Try this instead

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

Re: Creating a dimension to select a list of values

Although this should be enough because WildMatch function is case insensitive

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

nelrhaffouli
New Contributor

Re: Creating a dimension to select a list of values

Perfect!! Thank you so much for your help today :-)

Community Browser