IN/Not IN in Qlik Script

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: IN/Not IN in Qlik Script

marcus_sommer — Sat, 25 Feb 2017 17:20:38 GMT

Try this:

where not match(Product_Key, 5,6);

- Marcus