topic Re: Sum when null in QlikView

Sum when null

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

I'm trying to sum the T$PRIS amount when T$ACCT2 is null. This is what I'm trying so far but it does not work.

sum({$<T$ACCT2={''}>}T$PRIS)

marcos_rv_666 — Wed, 13 Mar 2019 19:39:05 GMT

Hola, como estas?

No se puede, es un problema que tiene qv con los nulos,

intenta lo siguiente:

Load *

if ( isnull(T$ACCT2), 1 , 0) AS NULL_T$ACCT2

RESIDENT TABLE1;

En tu grafico podes usar:

sum({$<NULL_T$ACCT2={1}>}T$PRIS)

Load id, field1, field2,

if ( isnull(T$ACCT2), 'NULL' , T$ACCT2) AS T$ACCT2

FROM TABLE1;

sum({$<T$ACCT2={'NULL'}>}T$PRIS)

Saludos!!!

vishsaggi — Wed, 13 Mar 2019 19:42:30 GMT

May be this ?
= sum({$<T$ACCT2={"=Len(Trim(T$ACCT2))=0"}>}T$PRIS)