topic Re: Where condition in a qvd load in QlikView

Where condition in a qvd load

Joaquin_Lazaro — Fri, 06 Mar 2015 09:44:42 GMT

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 — Fri, 06 Mar 2015 09:49:52 GMT

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 — Fri, 06 Mar 2015 09:53:02 GMT

Thank you very much.

Joaquín