Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
in fact it works well sorry