Where condition in a qvd load

[Joaquin_Lazaro]

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

[anbu1984 · Accepted solution]

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

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

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

[Joaquin_Lazaro]

HI anbu1984

Thank you very much.

Joaquín