Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtj
Creator II
Creator II

Data editor and WHERE IN

Hi,

i am fetching data from a QVD in the data editor and i would like to perform a SQL equivalent of WHER IN.

Can anybody tell me how to do this?

Basically like this:

LOAD

  *

FROM [lib://MyFolder/test.qvd] (qvd)

 

WHERE (my_field NOT IN (20, 30)

;

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

U can using match function

LOAD

  *

FROM [lib://MyFolder/test.qvd] (qvd)

WHERE not match(my_field,'20','30');

View solution in original post

5 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

There is no IN operator in QV/QS. Use Match instead:


     WHERE (Match(my_field, 20, 30) = 0)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

Hi,

U can using match function

LOAD

  *

FROM [lib://MyFolder/test.qvd] (qvd)

WHERE not match(my_field,'20','30');

Chanty4u
MVP
MVP

try this

where my_field not in('d','c','f');

schmidtj
Creator II
Creator II
Author

Thank you!

schmidtj
Creator II
Creator II
Author

Thank you!