Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm fetching data from below table.
TableA:
ID, Value
1, 58
2, 80
3, 90
4, - 50
5, - 45
6,
7,
8, 78;
I want to fetch all the data excluding negative values. I have used below condition in Qlik script.
Load * from TableA where values>0;
But it also excluding null values but I want those null values as well. ID 7,8 contain null values. Please suggest.
Load *
from TableA
where if(len(Values)>0,Values>0) or Len(Values)=0;
Load *
from TableA
where if(len(Values)>0,Values>0) or Len(Values)=0;
What if you turn the logic around like this
Load * from TableA where NOT values<0;
This condition is also excluding null values.