Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

right then either of these should work:

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

or

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

View solution in original post

10 Replies
Chanty4u
MVP
MVP

WHERE NOT EXISTS (id,1)

sunny_talwar

Try this:

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

sunny_talwar

This should also work:

Where ID <> 100 or Count <> 1;

Anonymous
Not applicable
Author

Try like this?

Load

*

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

Not applicable
Author

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
Author

!

sunny_talwar

right then either of these should work:

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

or

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

Chanty4u
MVP
MVP

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

sunny_talwar

What is your desired output for the attached qvw?