topic Re: Implement cumulative sum in pivot table in QlikView

Implement cumulative sum in pivot table

swarup_malli — Fri, 12 Jun 2015 17:22:57 GMT

Hi,

I have a Pivot table which uses advanced set analysis

It has been converted into a cross table.

Currently the Table looks like this (see fig below)

The resulting chart table should look like (see below)

Re: Implement cumulative sum in pivot table

petter — Fri, 12 Jun 2015 18:10:44 GMT

Re: Implement cumulative sum in pivot table

swarup_malli — Fri, 12 Jun 2015 18:22:30 GMT

Thanks for the response Petter

I was looking for cumulative sum ,the app You attached has a calculated dimension

Re: Implement cumulative sum in pivot table

sunny_talwar — Fri, 12 Jun 2015 19:18:41 GMT

This seems like what you want:

Expression:

=RangeSum(Before((Sum({<REPORT_YEAR={2014}>}FLIGHT_HRS)/COUNT({<REPORT_YEAR={2014}>} AC_SERIAL) * COUNT({<REPORT_YEAR={2014}>} AC_SERIAL)) -

Before(TOTAL (Sum(FLIGHT_HRS)/COUNT(AC_SERIAL)) * COUNT(AC_SERIAL)), 0, 2))

Also attaching your qvw for reference.

Best,

Sunny

Re: Implement cumulative sum in pivot table

swarup_malli — Fri, 12 Jun 2015 19:48:56 GMT

Wow !

That was some serious advanced analysis

Great Job ! my friend

Re: Implement cumulative sum in pivot table

sunny_talwar — Fri, 12 Jun 2015 19:56:29 GMT

I did not do much there, just used your expression and wrapped around it the RangeSum(Before()) function..., but I am glad we were able to figure it out.

Best,

Sunny