topic Re: Straight Table Cumulative sum by dimension in QlikView

Straight Table Cumulative sum by dimension

jbird — Sat, 16 Nov 2024 03:06:32 GMT

Hello,

I am having challenges using the rangesum( above function. I have a straight table with 5 dimensions. I have a simple sum for all of my values (entrees) in one column. Next to it, I'm trying to calculate a cumulative sum but only aggregated by the first dimension in the table. The TOTAL function is giving me the sum for the entire column and not restarting when the first dimension changes. I've copied a picture with some of the formulas that I am running. I've highlighted in yellow where the cumulative sum needs to start over. I need it to end at 147 and start over with 1. Help is much appreciated.

Re: Straight Table Cumulative sum by dimension

chrismarlow — Wed, 03 Jul 2019 20:34:06 GMT

Hi,
Is it not just a case of taking out the TOTAL from RowNo(TOTAL)?
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/rowno.htm
Cheers, Chris.

Re: Straight Table Cumulative sum by dimension

jbird — Wed, 03 Jul 2019 21:55:08 GMT

Thanks for the reply Chris, but unfortunately that does not work either. Below is an image of the output; it essentially gives me the same as sum(entrees).

I tried another formula:

If( above( total unique_id)=unique_id, rangesum( entrees, above(total entrees)),1)

However, this only sums up the current row and one row above, not the cumulative rows above with the unique_id.

Re: Straight Table Cumulative sum by dimension

chrismarlow — Thu, 04 Jul 2019 18:55:13 GMT

Hi,

That is odd, there must be something different between the data you have and the set I put together to try to check it;

Attaching QVW.

Cheers,

Chris.

Re: Straight Table Cumulative sum by dimension

chanti126 — Fri, 02 Sep 2022 06:26:05 GMT

Hello Jbrid,

Have you found the solution for this If so could please let me know now i am facing the same iisue.

Thanks in advance !