topic Where clause in QlikView

Where clause

Mon, 15 Feb 2016 12:13:03 GMT

Hi,

following table:

ID, Count

100, 1

200, 5

300, 4

100, 5

100, 4

200, 1

If ID = 100 and Count = 1 he should not load this data but everything else.

I thought that where ID <> 100 and Count = 1 should work but in this case he delete everything which have ID 100 and count1. But I need this where clause in a combination [ID = 100 AND Count = 1]!!!

Thanks

Re: Where clause

Chanty4u — Mon, 15 Feb 2016 12:15:10 GMT

WHERE NOT EXISTS (id,1)

Re: Where clause

sunny_talwar — Mon, 15 Feb 2016 12:16:36 GMT

Try this:

Where not (ID = 100 and Count = 1);

Re: Where clause

sunny_talwar — Mon, 15 Feb 2016 12:17:49 GMT

This should also work:

Where ID <> 100 or Count <> 1;

Re: Where clause

Anonymous — Mon, 15 Feb 2016 12:23:57 GMT

Try like this?

Load

from YourTable where ID <> 100 or Count <> 1;

Re: Where clause

Mon, 15 Feb 2016 12:24:38 GMT

I need a combination look at my example if Object = A and Anzahl > 2 this should not be loaded...

IF Object = A and Anzahl = 1 It must be loaded!

Re: Where clause

Mon, 15 Feb 2016 12:25:26 GMT

Re: Where clause

sunny_talwar — Mon, 15 Feb 2016 12:26:31 GMT

right then either of these should work:

Where not (Object = 'A' and Anzahl > 2);

Where Object <> 'A' or Anzahl <= 2;

Re: Where clause

Chanty4u — Mon, 15 Feb 2016 12:27:39 GMT

Where not Exists (Object = 'A' and Anzahl > 2);

Re: Where clause

sunny_talwar — Mon, 15 Feb 2016 12:29:23 GMT

What is your desired output for the attached qvw?

Re: Where clause

Mon, 15 Feb 2016 12:32:24 GMT

Hi Hans,

Can you try below.

where ((Object = A and Anzahl <=2) or (Object<>'A'))

Thanks,
Sreeman.