topic Re: Running Total/Average in QlikView

Running Total/Average

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How I may get the above results in a given series of data array which might look something like below!

Thanks

Neville

Item	2012	2013	2014	2015	2016	2017
revenue	250,000	352,000	325,000	325,000	450,000	500,000
Expenses	100,000	75,000	85,000	50,000	75,000	85,000

Running Total	250,000	602,000	927,000	1,252,000	1,702,000	2,202,000
Running Average	250,000	301,000	309,000	313,000	340,400	367,000

Re: Running Total/Average

sergio0592 — Tue, 05 Sep 2017 18:21:44 GMT

Hi, in your pivot chart, try with the following expression :

after(rangesum(Before(Sum(Revenue),1,ColumnNo())))

Re: Running Total/Average

sergio0592 — Tue, 05 Sep 2017 18:24:58 GMT

For running total, a better way with :

rangesum(First(Sum(Revenue),1,ColumnNo()))

Re: Running Total/Average

nevilledhamsiri — Tue, 05 Sep 2017 19:09:42 GMT

Hi!

Dear,

See where I have gone wrong!. It looks like results are not produced!

RangeSum(First(Sum(REVENUE),1,ColumnNo()))

After(RangeSum(Before(Sum(REVENUE),1,ColumnNo())))

Re: Running Total/Average

sunny_talwar — Tue, 05 Sep 2017 19:12:39 GMT

If Year is going down instead of going across, try this

Running Total

RangeSum(Above(Sum(REVENUE), 0, RowNo()))

Running Average

RangeAvg(Above(Sum(REVENUE), 0, RowNo()))

Re: Running Total/Average

vvira1316 — Tue, 05 Sep 2017 19:30:37 GMT

Hi,

Please find calculations for Running Total and Average

Total

=RangeSum(Above(TOTAL RangeSum(Revenue), 0, RowNo(TOTAL)))

Average

=RangeAvg(Above(TOTAL RangeSum(Revenue), 0, RowNo(TOTAL)))

As Sunny mentioned about data and above was using his other response

Running Total in a graph

Re: Running Total/Average

sergio0592 — Tue, 05 Sep 2017 19:43:18 GMT

In your sample for me it was a pivot chart with Item as dimension and Year as column. If it's a straight table with only year as dimension, as said by Sunny, use above() or top() with

rangesum(Top(Sum(Revenue),1,RowNo()))

Re: Running Total/Average

nevilledhamsiri — Wed, 06 Sep 2017 18:53:06 GMT

HI!

Great! Results were produced instantly. Dear Sunny & the rest of the guys, please accept my good wishes!