Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
safik003
Contributor III
Contributor III

Exclude only negative value

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. 

 

Labels (1)
1 Solution

Accepted Solutions
bharathadde
Creator II
Creator II

Load *

from TableA 

where if(len(Values)>0,Values>0) or Len(Values)=0;

View solution in original post

3 Replies
bharathadde
Creator II
Creator II

Load *

from TableA 

where if(len(Values)>0,Values>0) or Len(Values)=0;

Vegar
MVP
MVP

What if you turn the logic around  like this

Load * from TableA where NOT values<0;

safik003
Contributor III
Contributor III
Author

This condition is also excluding null values.