topic Re: Accumulation in script .. in QlikView

Accumulation in script ..

sibideepak — Mon, 13 Oct 2014 09:24:35 GMT

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

Re: Accumulation in script ..

anbu1984 — Mon, 13 Oct 2014 09:43:04 GMT

Can you post your script

Re: Accumulation in script ..

ashfaq_haseeb — Mon, 13 Oct 2014 09:47:48 GMT

Hi,

Check anbu cheliyan reply here

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

Regards

ASHFAQ

Re: Accumulation in script ..

sibideepak — Mon, 13 Oct 2014 09:48:17 GMT

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;

Re: Accumulation in script ..

sibideepak — Mon, 13 Oct 2014 10:21:45 GMT

help needed !!

Re: Accumulation in script ..

anbu1984 — Mon, 13 Oct 2014 11:07:49 GMT

LOAD *,Year(TargetDate) as New_Year,

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

target2:

LOAD Date#(TargetDate,'D-M-YYYY') As TargetDate,product,Quantity 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 New_Year,TargetDate, Only(product) as product,sum(Quantity) as Quantity,max(if(New_Year <> Previous(New_Year),0,(if(isnull(Previous(Q2)),0,Previous(Q2))))) as from,Only(Q2) as to Resident target2 Group by TargetDate,New_Year

Order by New_Year;

DROP Table target2;

Re: Accumulation in script ..

sibideepak — Mon, 13 Oct 2014 11:22:59 GMT

Thanks anbu ,

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