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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.