Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Multiple values for WHERE clause

Is there an IN statemeent in Qlikview as part of the laod script?

i.e I an trying to load * where fieldvalue in('a','b')

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Bruce's answer is correct:

LOAD *WHERE MATCH(ID, 1, 2, 3) > 0 FROM ....;


Will return those records where ID is 1, 2 or 3.

Regards.

View solution in original post

4 Replies
suniljain
Master
Master

you can use 'and' or 'or' operator according to your requirement

Not applicable

Alan

Also you can use Match (or it's deritives). For one or 2 selections Sunil's suggestions is good.

Miguel_Angel_Baeyens

Bruce's answer is correct:

LOAD *WHERE MATCH(ID, 1, 2, 3) > 0 FROM ....;


Will return those records where ID is 1, 2 or 3.

Regards.

johnw
Champion III
Champion III

And you technically don't need > 0 because any non-zero number evaluates to true. It makes me uncomfortable counting on QlikView's internal representation for true() and false(), but it's not something that would ever change, so it should be safe. I do it, and have just accepted being uncomfortable.