topic Write this SQL sentence but in QLIK script in QlikView

Write this SQL sentence but in QLIK script

Anonymous — Fri, 17 Aug 2018 20:12:10 GMT

Hi there!

How can I write this sentence in SQL but in a way that works in qlik?

select a.id

from table1 a

where a.id in (1, 5, 9)

I try the code below, bit seems that "in" in the "where" part doesn't work. The resident "table1" table exists and it contains data.

idTable:

LOAD id

Resident table1

where id in (1,5,9);

The 1, 5 and 9 are an example. I have much more items to consider, so replacing with "or" condition is not an option, or it'll be my last option.

Thanks in advance.

vishsaggi — Fri, 17 Aug 2018 20:25:01 GMT

Try this using Match function like

you can add additional values in match by giving comma.

idTable:

LOAD id

Resident table1

where MATCH(ID, 1,5,9)>0;

Anonymous — Fri, 17 Aug 2018 20:28:59 GMT

Awesome. That's exactly what I need. Thanks!

vishsaggi — Fri, 17 Aug 2018 20:36:14 GMT

No problem.