How to use filter (where not in) in QV script - Qlik Community

Report Inappropriate Content · ‎2013-09-23

this what we are using in sql scipting while generating qvd

AND THE.CallerID NOT IN (45,67,667,288)

but i wanted to apply this filter to qvd before reload.

can anyone help me.

thanks in advance.

rbecher · ‎2013-09-23

Hi,

you can probably use:

AND NOT Match(THE.CallerID, 45, 67, 667, 288)

- Ralf

Astrato.io Head of R&D

yavoro · ‎2013-09-24

rather use it like this: AND Match(THE.CallerID, 45, 67, 667, 288) = 0

Y.A.

rbecher · ‎2013-09-24

Same result but hard to read..

Astrato.io Head of R&D

yavoro · ‎2013-09-24

Maybe this is the best option then (just found it):

AND NOT EXISTS (THE.CallerID,45,67,667,288)

Never used it myself, but will do next time I need something like that.

Regards

Y.A.