IN/Not IN in Qlik Script

[mhmmd_srf]

Hi All,

This is in Qlikview.

I am writing a script where data is loading from qvd.

Now I want to put condition like below:

where Product_Key not in (5,6)

It is not working. Even Not Exists also not working How to handle this.

Please help.

Thanks,

Sarif

[marcus_sommer · Accepted solution]

Try this:

where not match(Product_Key, 5,6);

- Marcus