Multiple values for WHERE clause

[alan_grn]

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')

[suniljain]

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

[#3]

Alan

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

[Miguel_Angel_Baeyens · Accepted solution]

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]

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.