topic Where statement with IN() clause in QlikView

Where statement with IN() clause

paulsparrow — Tue, 23 Aug 2016 15:19:33 GMT

How do you do a LOAD with a WHERE clause that has an IN (...,...,..) statement. In other words I want my where condition to have multiple instances.

Re: Where statement with IN() clause

jpenuliar — Tue, 23 Aug 2016 15:26:19 GMT

You can use Match() in place of IN()

Using IN clause in QlikView – Learn QlikView

Re: Where statement with IN() clause

maxgro — Tue, 23 Aug 2016 15:33:39 GMT

test:

LOAD

rowno() as Field1,

rand() * 100 as Field2

AutoGenerate 100;

output:

NoConcatenate load

Resident test

where match(Field1, 1, 2, 3, 4, 5, 100);

DROP Table test;

Re: Where statement with IN() clause

paulsparrow — Tue, 23 Aug 2016 15:45:01 GMT

Thanks.

Re: Where statement with IN() clause

oknotsen — Tue, 23 Aug 2016 15:53:38 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .