Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
robert2012
New Contributor III

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

Re: resident where "or"/"and"

HI

Try like this

Load *

resident test

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

2 Replies

Re: resident where "or"/"and"

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

Re: resident where "or"/"and"

HI

Try like this

Load *

resident test

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

Community Browser