topic Re: why this simple formula does not work in my script? in QlikView

why this simple formula does not work in my script?

doespirito — Wed, 10 Apr 2019 15:28:48 GMT

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

Re: why this simple formula does not work in my script?

wandererroch — Wed, 10 Apr 2019 16:04:29 GMT

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.

Re: why this simple formula does not work in my script?

doespirito — Wed, 10 Apr 2019 16:12:13 GMT

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

Re: why this simple formula does not work in my script?

doespirito — Wed, 10 Apr 2019 16:25:28 GMT

in fact it works well sorry

Re: why this simple formula does not work in my script?

Gysbert_Wassenaar — Mon, 15 Apr 2019 15:17:32 GMT

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