why this simple formula does not work in my script?

[doespirito]

hi every body,

here is my script :

LOAD KeyTemp1,
ANNEE_CARTO,
MOIS_CARTO,
INSEE,
%KeyField,
%KeyCumul,
OJD_A,
OJD_A_1,

OJD_A - OJD_A_1 as Ecart_M // écart OJD année A vs OJD année A_1

FROM
[D:\QlikviewData\SourceDocuments\VENTES\QVD_zmsd_carto\zmsd_c3_modif.qvd]
(qvd);

OJD_A - OJD_A_1 as Ecart_M is given the difference between OJD_A and OJD_A_1

but for a line, the script gives nothing.

Does anyone know why ?

Thank you very much

Arnault

si the files attached

[wandererroch · Accepted solution]

I believe QlikView returns a null when adding two fields if one of those fields is null. You'd have to use an if statement to replace null with 0 to get a result.

[doespirito]

thank you i've just try to use this :

if(IsNull(OJD_A),0,OJD_A) as OJD_A,
if(IsNull(OJD_A_1),0,OJD_A_1) as OJD_A_1

in a previous script

before but it still doesen't work 

[doespirito]

in fact it works well sorry 

[Gysbert_Wassenaar]

You can use the rangesum function which will some everything that has a value and will ignore nulls
RangeSum(OJD_A, -OJD_A_1) as Ecart_M