Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IN is not available in Qlikview. Instead you can use Match()
MyFile:
LOAD *
FROM Myqvd.qvd (qvd)
WHERE Match(Field, 'A', 'B', 'C') ;
IN is not available in Qlikview. Instead you can use Match()
MyFile:
LOAD *
FROM Myqvd.qvd (qvd)
WHERE Match(Field, 'A', 'B', 'C') ;