topic Re: How to use filter (where not in) in QV script in QlikView

How to use filter (where not in) in QV script

Mon, 23 Sep 2013 19:37:31 GMT

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 — Mon, 23 Sep 2013 20:45:06 GMT

Hi,

you can probably use:

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

- Ralf

yavoro — Tue, 24 Sep 2013 09:03:14 GMT

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

rbecher — Tue, 24 Sep 2013 12:15:12 GMT

Same result but hard to read..

yavoro — Tue, 24 Sep 2013 13:53:04 GMT

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