Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Resident load where field is not null

Hi,

I'm trying to restrict a resident load to where a particular field is null.

I've tried

RESIDENT TableName

WHERE NOT FieldToCheck IS NULL;

But this didn't work.

I can't do the restriction in the sql load statement, since I need the cases where the field is null to be present in another resident load.

Any help would be appreciated.

1 Solution

Accepted Solutions
jsn
Not applicable

Resident load where field is not null

Perhaps try something like:

Resident TableName

Where Len(FieldToCheck)>0;

4 Replies
jsn
Not applicable

Resident load where field is not null

Perhaps try something like:

Resident TableName

Where Len(FieldToCheck)>0;

Not applicable

Resident load where field is not null

Worked great thanks.

jdvermeire
Not applicable

Re: Resident load where field is not null

Why not do this:

Resident TableName

WHERE not IsNull(FieldToCheck);

I believe the "IsNull" function is less expensive than the "Len" function.

jsn
Not applicable

Re: Resident load where field is not null

Hey Jeff,

That should give the same result and might cost less as you say.

The reason that me, and several others are hooked on the len() function is that there used to be a difference.. back in early QV 8 if I remember correctly, where the results from IsNull() varied based on your platform (32 vs 64 bit) while len() was consistent.

These days, IsNull() should be the easier option.

Cheers,

Johannes