topic Re: IsNull function in QlikView

IsNull function

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

Good day!

I can't get the idea why IsNull function dosn't work properly in my LOAD statement.

When, my SUM has values, I get an adequete result. Still, I can't convert Null data to ZERO values.

Please help!

Re: IsNull function

tresB — Tue, 17 Jul 2018 10:13:35 GMT

Sum of null values , i.e. Sum(Null()) would give zero itself, isn't it?

Re: IsNull function

sculptorlv — Tue, 17 Jul 2018 10:14:54 GMT

Unfortunatelly no It would give NULL, thus I would not be able to do mathematical calculations with it.

Re: IsNull function

YoussefBelloum — Tue, 17 Jul 2018 10:17:17 GMT

Hi,

try this

if(len(trim(sum(quantity_reserved))=0,0...

Re: IsNull function

sculptorlv — Tue, 17 Jul 2018 10:23:09 GMT

Same result

Re: IsNull function

fvelascog72 — Tue, 17 Jul 2018 10:23:34 GMT

Hi,

I try this:

Data1:

LOAD

Item,

If(Qty = '', null(), Qty) as Qty

INLINE [

Item, Qty

5, 10

];

NoConcatenate

Data2:

LOAD

Item,

Sum(Qty) as Qty

Resident Data1

Group by Item

;

DROP Table Data1;

Saludos

Re: IsNull function

tresB — Tue, 17 Jul 2018 10:24:14 GMT

I guess, the problems lies somewhere else. Could you post a sample qvw with sample data ?

Re: IsNull function

MindaugasBacius — Tue, 17 Jul 2018 10:41:31 GMT

Try this work around:

tmp:

LOAD Item_number

,Sum(Quantity_Reserved) as Quantity_Reserved

Resident RESERVED

Group By Item_number

;

NoConcatenate

tmp2:

LOAD Item_number

,If(Len(Trim(Quantity_Reserved)) = 0, 0, Quantity_Reserved) as Quantity_Reserved2

Resident tmp;

DROP Table tmp;

Rename Field Quantity_Reserved2 to Quantity_Reserved;

Re: IsNull function

sculptorlv — Tue, 17 Jul 2018 11:22:00 GMT

I don't understand WHY!!! but it works.. thank you!