topic Cumulative SUM in Qlik Expression in QlikView

Cumulative SUM in Qlik Expression

gsiva1220 — Thu, 05 Oct 2017 09:19:37 GMT

Hi Experts,

I explain what I would like to achieve in Qlikview, I have a below data,

I would like to calculate the Qty and show it as below

Can anyone please let me know, how can I achieve the expected Qty using set analysis or other expressions.

sunny_talwar — Thu, 05 Oct 2017 15:32:52 GMT

May be try this

RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))

elintham — Mon, 22 Oct 2018 07:02:19 GMT

Hi Sunny,

I've been looking through your answers to Qlik Community Questions on Cumulative Sum.

Would you be able to help with this one?

We're having troubles trying to get the cumulative percentage in a pivot table?
Please see this thread:

Thank you!!

DSDD — Wed, 03 Feb 2021 17:42:24 GMT

Hi Sunny,

is it possible to calculate the cumulative sum for a further grouping-dimension.

Let say i have a field with two categories and i want to display the cumulative qty in a line chart with two lines

How do i adjust the expression to consider the grouping dimension?