Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Where clause

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

1 Solution

Accepted Solutions

Re: Where clause

right then either of these should work:

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

or

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

10 Replies
sureshqv
Esteemed Contributor III

Re: Where clause

WHERE NOT EXISTS (id,1)

Re: Where clause

Try this:

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

Re: Where clause

This should also work:

Where ID <> 100 or Count <> 1;

balrajahlawat
Esteemed Contributor

Re: Where clause

Try like this?

Load

*

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

Not applicable

Re: Where clause

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!

Not applicable

Re: Where clause

!

Re: Where clause

right then either of these should work:

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

or

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

sureshqv
Esteemed Contributor III

Re: Where clause

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

Re: Where clause

What is your desired output for the attached qvw?

Community Browser