Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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