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: 
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Where condition in a qvd load

Hello:

I wish to know if is possible write a IN or LIST condition instead a sequence of OR in a LOAD FROM QVD

This is what I have

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

WHERE Field = 'A' or Field = 'B' or Field = 'C' ;

This is what I would like

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

WHERE Field IN ( 'A', 'B', 'C') ;

Thank you very much,

Joaquín

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

IN is not available in Qlikview. Instead you can use Match()

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

WHERE Match(Field, 'A', 'B', 'C') ;

View solution in original post

2 Replies
anbu1984
Master III
Master III

IN is not available in Qlikview. Instead you can use Match()

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

WHERE Match(Field, 'A', 'B', 'C') ;

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

HI anbu1984


Thank you very much.


Joaquín