topic sum when empty in QlikView

sum when empty

Mon, 14 Oct 2013 06:59:14 GMT

Hi all,

This part of my expression does not want to work. When Ontvangst_Ontvangstdatum is empty it should sum Inkoopfactuurregel_Aantal, alternatives are welcome too.

Thanks!

Sum(
{<
Ontvangst_Ontvangstdatum -= {'*'}
>}
Inkoopfactuurregel_Aantal
))

Re: sum when empty

vivientexier — Mon, 14 Oct 2013 08:01:43 GMT

Hello,

In your script, add a flag to your field Ontvangst_Ontvangstdatum.

If(Len(Ontvangst_Ontvangstdatum)=0, 1) as Ontvangst_Ontvangstdatum_flag

then, all you neeed to do is :

Sum(
{<
Ontvangst_Ontvangstdatum_flag = {1}
>}
Inkoopfactuurregel_Aantal
)

Re: sum when empty

Mon, 14 Oct 2013 08:14:52 GMT

Thank you for this most simple answer,

will use the method in general!

THANKS!

Re: sum when empty

lironbaram — Mon, 14 Oct 2013 08:17:28 GMT

may try to use

Sum(
if isnull( Ontvangst_Ontvangstdatum),
Inkoopfactuurregel_Aantal
))

Re: sum when empty

Mon, 14 Oct 2013 08:22:45 GMT

Thanks Liron,

but that was my expression before my solution. The Isnull Function does not always work for me, esspeccially when you start summing up the expressions is rarely gives the right answer.

Thanks, Im working witht the option Vivien gave, this seems to work fine.

regards,