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

resident where "or"/"and"

Hi all,

I have a resident load combined with where like and 3 possibilities:

Load *

resident test

where field1 like  'A' or 'B' or 'C'; // the or doesn't work !?

It only works for one, ex: where field1 like  'A' ;

How do I have to put A, B and C in the skript?

Thank you for helping!

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

Load *

resident test

where wildmatch(field1,'A' ,'B' , 'C');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

... where field1 like 'A*' or field1 like 'B*' or ....

MayilVahanan

HI

Try like this

Load *

resident test

where wildmatch(field1,'A' ,'B' , 'C');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.