topic Calculated field with null values in QlikView

Calculated field with null values

Wed, 08 Jun 2011 18:30:30 GMT

Hi experts,

Here is my problem :

I aim at calculating a field with 2 other fields :

--------------------------------------------

LOAD Date,

Libellé,

Débit,

Crédit,

Crédit + Débit as Delta

FROM

.....

--------------------------------------------

The problem is when one of the 2 values is null, Delta displays null too.

I think the best way to resolve it is to convert the null values to 0, before the calculation of "Delta"

Could anyone tell me how to do that ?

Regards,

Pierre.

erichshiino — Wed, 08 Jun 2011 19:06:21 GMT

You can use

RangeSum( Crédti, Débit) as Delta

Hope this helps,

Erich

Wed, 08 Jun 2011 19:21:05 GMT

I've read that isnull can give inconsistent results in 64 bit environments so a method using len is also here.

load

loadtime,

if(isnull(value),0,1) as isnull_value,

if(len(value)=0,0,1) as len_value

;

load

now() as loadtime,

null() as value

autogenerate 1;