Filter Data from Import

[ColinMAD]

Hey Everyone,

I am relatively new to QlikSense, and working on putting together some reports.

I am trying to filter the data that my app is importing from a PostgreSQL database, and have managed most, but stuck on one: I am trying to filter out all the entries that have a null value in a column (these are heaaders, portfolio names, etc), and it doesn't seem to work.

I have tried column<>NULL and column=NULL in the filter section of the data edit import page, but does not seem to work. 

Any ideas?

THX

[StarinieriG]

Hi,

you could try with:

Load * where Len(Trim(Field))=0;

[_armoco_]

Hi,

Try like,

TableName:

Load 

a,

b,

c

from....

where fieldname<>null();

Or like already mentioned by someone you can also use len function and say where len(fieldname)>0

Regards,

Arjun

[otmane]

Hi ColinMAD,

Null in Qlik is a function, so to use it you have 3 choices:

-  where not( IsNull(YourField))

- YourField<>null()

- Len(YourFeield)=0

If this not work, please provide your script.a

regards

Otmane