Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

joaquinlr
Valued Contributor 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

Tags (6)
1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Where condition in a qvd load

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

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

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

2 Replies
anbu1984
Honored Contributor III

Re: Where condition in a qvd load

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

MyFile:

LOAD *

FROM Myqvd.qvd (qvd)

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

joaquinlr
Valued Contributor II

Re: Where condition in a qvd load

HI anbu1984


Thank you very much.


Joaquín