Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
reivax31
Partner - Creator III
Partner - Creator III

NOT LIKE

Hi Qlikers,

I'm loading a Table and based on the informations I have in the field 'comment' I would like to build a new field Status.

LOAD

comment,

if(comment like '*Test*', 'Test',

if(comment like '*Blocked*', 'Blocked',

if(comment NOT LIKE '*check*' and NOT LIKE '*analyse*', 'To be checked',

if(comment like ......))))  AS Status

From ...

Thanks for your help

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Not Wildmatch(comment, '*check*','*analyse*')


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

Not Wildmatch(comment, '*check*','*analyse*')


talk is cheap, supply exceeds demand
kaushiknsolanki

Hi,

Use the wildmatch function.

if(Wildmatch(comment,'*Test*'), 'Test',

if(Wildmatch(comment,'*Blocked*'), 'Blocked',

...............

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
sunny_talwar

And if you insist on using LIKE, you can try this:

if(not comment LIKE '*check*' and not comment LIKE '*analyse*', 'To be checked',

reivax31
Partner - Creator III
Partner - Creator III
Author

It worked perfectly! thanks for your help

reivax31
Partner - Creator III
Partner - Creator III
Author

Thanks for this solution