Discussion Board for collaboration on QlikView Scripting.
How can I write this sentence in SQL but in a way that works in qlik?
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.
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.
Try this using Match function like
you can add additional values in match by giving comma.
where MATCH(ID, 1,5,9)>0;
View solution in original post
Awesome. That's exactly what I need. Thanks!