Accumulate in the script

fkeuroglian — Fri, 20 Nov 2015 01:24:51 GMT

Hi expert!

I have to create a accumulate value month by month. but my problem is that i use the peek function but there is some month that i do not have any value, and i want to acumulate not only the previous field, i want to acumulate all

for example:

Jan 2015 10

Feb 2015 5

Apr 2015 15

Jul 2015 40

I would like

Jan 2015 10

Feb 2015 15

Apr 2015 30

Jul 2016 70

i use this, but only sum the previous register

SAEC_ACUMULADA:

load *,

Peek('SuperficieTotal')+ SuperficieTotal as Acumulada

Resident SAEC_AGRUPADA;

what is the best way to do this?

thank you a lot

Fernando

attach an image and the qvw and qvd for example

Re: Accumulate in the script

settu_periasamy — Fri, 20 Nov 2015 03:06:33 GMT

Try this..

Load *,

[Superficie Total]+if (isnull (peek ('Acumulada')),0,peek ('Acumulada')) as Acumulada

Resident SAEC_AGRUPADA Order by MonthField;

topic Accumulate in the script in QlikView

Accumulate in the script

Re: Accumulate in the script