topic Re: Exclude only negative value in QlikView

Exclude only negative value

safik003 — Sat, 16 Nov 2024 02:01:06 GMT

I'm fetching data from below table.

TableA:

ID, Value

1, 58

2, 80

3, 90

4, - 50

5, - 45

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.

bharathadde — Wed, 06 Nov 2019 19:20:23 GMT

Load *

from TableA

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

Vegar — Wed, 06 Nov 2019 19:26:52 GMT

What if you turn the logic around like this

Load * from TableA where NOT values<0;

safik003 — Wed, 06 Nov 2019 20:12:42 GMT

This condition is also excluding null values.