topic Re: Filter Data from Import in Connectivity & Data Prep

Filter Data from Import

ColinMAD — Tue, 21 Dec 2021 17:11:40 GMT

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

Re: Filter Data from Import

StarinieriG — Fri, 18 Oct 2019 09:10:11 GMT

Hi,

you could try with:

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

Re: Filter Data from Import

_armoco_ — Fri, 18 Oct 2019 09:45:03 GMT

Hi,

Try like,

TableName:

Load

from....

where fieldname<>null();

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

Regards,

Arjun

Re: Filter Data from Import

otmane — Fri, 18 Oct 2019 13:47:34 GMT

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