topic Multiple values for WHERE clause in QlikView

Multiple values for WHERE clause

alan_grn — Tue, 19 Oct 2010 18:11:53 GMT

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

Multiple values for WHERE clause

suniljain — Tue, 19 Oct 2010 18:14:38 GMT

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

Multiple values for WHERE clause

Tue, 19 Oct 2010 18:48:22 GMT

Alan

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

Multiple values for WHERE clause

Miguel_Angel_Baeyens — Tue, 19 Oct 2010 21:23:10 GMT

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.

Multiple values for WHERE clause

johnw — Wed, 20 Oct 2010 00:44:40 GMT

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.