Discussion Board for collaboration related to Creating Analytics for QlikView.
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]!!!
Go to Solution.
right then either of these should work:
Where not (Object = 'A' and Anzahl > 2);
Where Object <> 'A' or Anzahl <= 2;
WHERE NOT EXISTS (id,1)
Where not (ID = 100 and Count = 1);
This should also work:
Where ID <> 100 or Count <> 1;
Try like this?
from YourTable where ID <> 100 or Count <> 1;
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!
Where not Exists (Object = 'A' and Anzahl > 2);
What is your desired output for the attached qvw?