Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
Master
Master

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

Highlighted
Not applicable

Alan

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

Highlighted

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

Highlighted
MVP
MVP

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.