Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
MvR
Contributor
Contributor

Cummulative sum in grouped chart

Hello all,

 

I am trying to get a chart like example below from a query which give me a tabel like attached excel. Goal is to get a cummulative total over the periods. So period 1 = Period 1, Period 2 = Period 1+2, etc.

Does anyone know how to achieve this?

Thanks in advance for your help.

Knipsel.JPG

Labels (3)
1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

I couldn't see the cumulative sum in ur graphic.
try this if u want cumulative sum
aggr(rangesum(above(sum(Amount),0,rowno())),Year,Period)

View solution in original post

3 Replies
OmarBenSalem
Partner
Partner

Create a bar chart:

as dimension:

dim1: Period

dim2: Year

As measure:

sum(Amount)

MvR
Contributor
Contributor
Author

Thank you for your suggestion, however this doesn't give me a cummulative sum
OmarBenSalem
Partner
Partner

I couldn't see the cumulative sum in ur graphic.
try this if u want cumulative sum
aggr(rangesum(above(sum(Amount),0,rowno())),Year,Period)

View solution in original post