topic Re: Double where clause? in QlikView

Double where clause?

Mon, 18 Jun 2012 13:05:24 GMT

Hi,

I am trying to create a Load Script, where I need to filter out some results.

I was trying to use:

where not "COLUMN A" = 'UDM' or 'UDT' or 'UDTR'

It will work if I have 1 criteria (UDM for instance), but as soon as I add more it only returns first value.

What am I doing wrong?

I would like to do something like this:

If you have a list, say

Then I am trying to load all data except A and C, which I would write as load all and then use Where not A or B

swuehl — Mon, 18 Jun 2012 13:09:23 GMT

Try

...where not match(FIELDNAME,'A','C');

jagan — Mon, 18 Jun 2012 13:10:38 GMT

Hi,

Try this

where [COLUMN A] <> 'UDM' OR

[COLUMN A] <> 'UDT' OR

[COLUMN A] <> 'UDTR'

Hope this helps you.

Regards,

Jagan.

Tue, 19 Jun 2012 06:43:27 GMT

That will give me 390.063 records instead of the 142.941 I had already. The extra clauses should give less results instead of more.

But actually I replaced your OR with AND and now it works.

Thanks