Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Cummulative sum expression

All,

I would like to calculate Cumulative total for the below sample data in the front end.

Can some one please help me out with the correct expression? Thanks

Product ID         Sales    Cumulative Total

A12                          20             20

A13                         30              50

A14                        40               70

A15                        50              90

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Cummulative sum expression

Try an expression like this:

sum( aggr( rangesum( above( sum(Sales),0,2) ),[Product ID]))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Cummulative sum expression

Try an expression like this:

sum( aggr( rangesum( above( sum(Sales),0,2) ),[Product ID]))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Cummulative sum expression

Perfect - Thanks