# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## Cumulative SUM in Qlik Expression

Hi Experts,

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

 Britem Creation Date Line Id Qty JXX19643 21-Jul-17 4869992 3 JXX19643 21-Jul-17 4957114 2 JXX19643 14-Aug-17 4908295 1 JXX19643 14-Aug-17 4908296 1 JXX19643 13-Sep-17 4955603 1 JXX19643 13-Sep-17 4955604 2 JXX19643 1-Sep-17 4937133 1

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

 Britem Creation Date Line Id Qty Expected Qty JXX19643 21-Jul-17 4869992 3 0 JXX19643 21-Jul-17 4957114 2 3 JXX19643 14-Aug-17 4908295 1 5 JXX19643 14-Aug-17 4908296 1 6 JXX19643 13-Sep-17 4955603 1 7 JXX19643 13-Sep-17 4955604 2 8 JXX19643 1-Sep-17 4937133 1 9

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

1 Solution

Accepted Solutions
MVP

May be try this

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

3 Replies
MVP

May be try this

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

Contributor

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?

Calculating Cumulative Percentage of Total by Column (Pivot Table)

Thank you!!

Contributor III

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?

Community Browser