topic Where not + condition in QlikView

Where not + condition

Wed, 27 Nov 2013 16:18:09 GMT

Hi,

I know how to use a "where not match" condition, but is it possible to use the same kind of statement with a condition to exclude data from a loaded table?

Like: Where not ... ([Salary]<50000);

Thank you

Re: Where not + condition

Clever_Anjos — Wed, 27 Nov 2013 16:23:38 GMT

Yes, you just wrote it

where not [Salary]<50000

Re: Where not + condition

tresB — Wed, 27 Nov 2013 17:23:00 GMT

May be like:

Load

Field1,

Field2,

Salary

Resident <tablename> Where Salary >=50000; // equivalent to 'not Salary<50000'