Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
gsiva1220
Contributor II
Contributor II

Cumulative SUM in Qlik Expression

Hi Experts,

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

    

BritemCreation DateLine IdQty
JXX1964321-Jul-1748699923
JXX1964321-Jul-1749571142
JXX1964314-Aug-1749082951
JXX1964314-Aug-1749082961
JXX1964313-Sep-1749556031
JXX1964313-Sep-1749556042
JXX196431-Sep-1749371331

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

     

BritemCreation DateLine IdQtyExpected Qty
JXX1964321-Jul-17486999230
JXX1964321-Jul-17495711423
JXX1964314-Aug-17490829515
JXX1964314-Aug-17490829616
JXX1964313-Sep-17495560317
JXX1964313-Sep-17495560428
JXX196431-Sep-17493713319

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this

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

View solution in original post

3 Replies
sunny_talwar

May be try this

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

View solution in original post

elintham
Contributor
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?
Please see this thread:

Calculating Cumulative Percentage of Total by Column (Pivot Table)

Thank you!!

DSDD
Contributor III
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?