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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ColinMAD
Contributor
Contributor

Filter Data from Import

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

Labels (2)
3 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

you could try with:

 

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

_armoco_
Partner - Creator II
Partner - Creator II

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
Contributor III
Contributor III

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