Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Exclude nulls from script

I need to exclude nulls from script.

15 Replies
fernando_tonial
Valued Contributor

Re: Exclude nulls from script

Hi, Try the function IsNull(Field)

LOAD * from Table Where Not IsNull(Field);

Best Regards.

Tonial.

regowins
Contributor II

Re: Exclude nulls from script

At the end of you script you can do somthing like

Where  Len(fieldname) > 1

Not applicable

Re: Exclude nulls from script

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

Re: Exclude nulls from script

Doesn’t work for my need.

Not applicable

Re: Exclude nulls from script

Doesn’t work for my need.

Not applicable

Re: Exclude nulls from script

Doesn’t work for my need.

pradeepreddy
Valued Contributor II

Re: Exclude nulls from script

Hi Paul,

What is the exact requirement?

Not applicable

Re: Exclude nulls from script

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

regowins
Contributor II

Re: Exclude nulls from script

What does your load script for this data look like ?

Community Browser