Accumulation in script

timmy — Thu, 12 Aug 2010 19:04:29 GMT

Hey

Underneed you can see my code where i try to accumulate Consommé_CONSO

SO the Consommé needs to be accumulated bases on the month(Mois de conso_MONTH_CONSO) and the Post Budg Int Numb_POSTBUDG

Directory;

test:

LOAD

%KEY_ZCONSOMMATION_ANBUD_TBUDGET,
Nr_ORG,
[Mois de conso_MONTH_CONSO],
[Post Budg Int Numb_POSTBUDG],
Consommé_CONSO

FROM

[Brussels Gewest\QlikViewStorage\Private Files\Data\ZCONSOMMATION.QVD]

(

qvd)

;

noconcatenate

tmp:
load
*
resident

test
order by [Post Budg Int Numb_POSTBUDG] asc,[Mois de conso_MONTH_CONSO]

asc;

drop

table

test;

Load

[Post Budg Int Numb_POSTBUDG],
[Mois de conso_MONTH_CONSO],
Consommé_CONSO,
if( ISNUll(peek(Consommé_CONSO)),Consommé_CONSO,Consommé_CONSO+peek(accum)) as
accum
resident
tmp order by [Mois de conso_MONTH_CONSO]

asc;

drop

table

tmp;

Accumulation in script

Thu, 12 Aug 2010 19:32:39 GMT

Hi,

The function ISNULL() return -1 for true and 0 for false, maybe you need to check the condition:

IF( ISNULL(....) = -1, Do....., Else....)

topic Accumulation in script in QlikView

Accumulation in script

Accumulation in script