topic Re: Resident load where field is not null in QlikView

Resident load where field is not null

Tue, 31 May 2011 01:14:17 GMT

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.

Resident load where field is not null

Anonymous — Tue, 31 May 2011 01:17:03 GMT

Perhaps try something like:

Resident TableName

Where Len(FieldToCheck)>0;

Resident load where field is not null

Tue, 31 May 2011 01:24:07 GMT

Worked great thanks.

Re: Resident load where field is not null

Anonymous — Tue, 31 Jan 2012 15:47:41 GMT

Why not do this:

Resident TableName
WHERE not IsNull(FieldToCheck);

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

Re: Resident load where field is not null

Anonymous — Wed, 01 Feb 2012 01:21:20 GMT

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

Re: Resident load where field is not null

Igoresz — Wed, 01 Jul 2020 05:51:42 GMT

where IsNull(num([field]))=0

😉