Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude nulls from script

I need to exclude nulls from script.

15 Replies
fernando_tonial
Partner - Specialist
Partner - Specialist

Hi, Try the function IsNull(Field)

LOAD * from Table Where Not IsNull(Field);

Best Regards.

Tonial.

Don't Worry, be Qlik.
regowins
Creator II
Creator II

At the end of you script you can do somthing like

Where  Len(fieldname) > 1

Not applicable
Author

Hi,

To load without nulls I usually put:

Where not(IsNull(FieldName))


Also works, for nulls and empty strings:

Where Len(FieldName)>0


To also exclude empty spaces:

Where Len(Trim(FieldName))>0


A remark: when you load from qvd or Excel, you have real null values; when you load from csv or txt, you get empty strings instead, but 2nd and 3rd formula work.


Hope this helps.

Not applicable
Author

Doesn’t work for my need.

Not applicable
Author

Doesn’t work for my need.

Not applicable
Author

Doesn’t work for my need.

PradeepReddy
Specialist II
Specialist II

Hi Paul,

What is the exact requirement?

Not applicable
Author

In the example below, I do not want the PSalesNumber (example numbers below) 2705, 2702,2699, etc. to appear.

regowins
Creator II
Creator II

What does your load script for this data look like ?