topic Re: How to calculate running total? in QlikView

How to calculate running total?

Tue, 02 Jul 2013 17:51:29 GMT

Hello!

I'm trying to figure out how to calculate a running total of daily cash on-hand for each month so that I may calculate the average daily cash on-hand for each month. So, for the month of July, I would need to get a cumulative sum of the amounts in the Desired Output column for the month of July and then divide by 31 (example: ($248,919)+($401,761)+($554,037)+....and so on for the 31 days of July).

The dollar amounts in the Daily Cash Total column are a dimension that I've calculated in the script. What I'm trying to figure out is how in QlikView to get the figures that I have in the Desired Output column:

Date	Expenses	Revenue	Total Daily Activity	Daily Cash Total	Desired Output
7/1/2012	67,700.00	(316,619.00)	(248,919.00)	(248,919.00)	(248,919.00)
7/2/2012	110,012.00	(13,935.00)	96,077.00	(152,842.00)	(401,761.00)
7/3/2012	566.00	0.00	566.00	(152,276.00)	(554,037.00)
7/4/2012	106,578.00	(15,582.00)	90,966.00	(61,310.00)	(615,347.00)
7/5/2012	8,542.00	(13,085.00)	(4,543.00)	(65,853.00)	(681,200.00)
7/6/2012	0.00	0.00	0.00	(65,853.00)	(681,200.00)

Any suggestions would be much appreciated.

Kind regards!

Re: How to calculate running total?

Gysbert_Wassenaar — Tue, 02 Jul 2013 18:04:53 GMT

Try rangesum(above(sum([Daily Cash Total]),0,rowno()))

Re: How to calculate running total?

gerald_lebret — Mon, 20 May 2019 19:27:42 GMT

Hello,

I know this post is quite old but I really need help. I have spent hours looking for an answer but can't find the correct one. I have a table with dates, accounts, amounts. I am trying to get a running total which seems easy. However, despite using a master calendar, I can't see the running total of a specific day if I don't have any entry that day.

Basically what I want to do is to be able to calculate my account balance at any time. Thus, if I don't have any entry on a specific day, I want to get the value of the running total the day before (or the day before that if there is no value).

I am stuck and would really really appreciate some help.

Thanks