topic Re: accumulated sum in script in QlikView

accumulated sum in script

ilanbaruch — Sat, 16 Nov 2024 18:58:27 GMT

hi all

in my model , i have a table with transactions quantity

I would want to add a field (Total) to accumulate the quantity in level of branch, item, transactions_date - i.e :

Date	Store	Item	Quantity	Total
31/12/2019	3	17761	1	1
02/02/2020	3	17761	-1	0
04/02/2020	3	17761	1	1

advanced thanks

Re: accumulated sum in script

Brett_Bleess — Thu, 02 Apr 2020 18:25:52 GMT

I would recommend you attach your QVW file on this one, so folks can see your data model etc. You really did not provide much to go on, which is likely why you have not received any posts.

Here are a couple of Design Blog posts that may be useful though:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010

Here is the base URL for this area in case you wish to further search on your own for more posts that may help:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: accumulated sum in script

Saravanan_Desingh — Sun, 07 Jun 2020 21:55:16 GMT

One solution is.

SET DateFormat='DD/MM/YYYY'; tab1: LOAD *, RangeSum(Peek(Total), Quantity) As Total ; LOAD * INLINE [ Date, Store, Item, Quantity 31/12/2019, 3, 17761, 1 02/02/2020, 3, 17761, -1 04/02/2020, 3, 17761, 1 ];

Re: accumulated sum in script

Saravanan_Desingh — Sun, 07 Jun 2020 21:56:09 GMT