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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.