Solved: Accumulation in script .. - Qlik Community

sibideepak · ‎2014-10-13

Hi ,

see attached image ,

I did to calculation like this : Quantity+Alt(Peek(Q2),0) As Q2

I did from calculation like this : if(isnull(Previous(Q2)),0,Previous(Q2)) As Q1

by doing resident .

what I want is accumulate year wise ..ie from , to is accumulated totally

but i want it for each year accumulation..

here in 2014 start , from should be 0 and to should be 5 in this case.

Thanks in advance ,

Deepak Sibi

sibideepak · ‎2014-10-13

Thanks anbu ,

but already i have also done it ..and finished it.

View solution in original post

anbu1984 · ‎2014-10-13

Can you post your script

ashfaq_haseeb · ‎2014-10-13

Hi,

Check anbu cheliyan reply here

http://community.qlik.com/thread/137531

Regards

ASHFAQ

sibideepak · ‎2014-10-13

Hi anbu,

here is my script

LOAD *,

Quantity+Alt(Peek(Q2),0) As Q2;

target2:

LOAD * INLINE [

TargetDate,product,Quantity

12-01-2013, A, 6

19-04-2013, A, 7

06-08-2013, A, 10

11-11-2013, A, 13

15-02-2014, A, 5

11-05-2014, A, 6

26-07-2014, A, 4

16-12-2014, A, 2

];

target1:

LOAD Year(TargetDate) as New_Year,TargetDate, Only(product) as product,sum(Quantity) as Quantity,max(if(isnull(Previous(Q2)),0,Previous(Q2))) as from,Only(Q2) as to Resident target2 Group by Year(TargetDate),TargetDate;

DROP Table target2;

sibideepak · ‎2014-10-13

help needed !!

anbu1984 · ‎2014-10-13

LOAD *,Year(TargetDate) as New_Year,