Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulsparrow
New Contributor II

Where statement with IN() clause

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.

4 Replies
jpenuliar
Valued Contributor III

Re: Where statement with IN() clause

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

Using IN clause in QlikView – Learn QlikView

MVP
MVP

Re: Where statement with IN() clause

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;

paulsparrow
New Contributor II

Re: Where statement with IN() clause

Thanks.

oknotsen
Honored Contributor III

Re: Where statement with IN() clause

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 .

May you live in interesting times!
Community Browser