Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Stevan_Klaas
Partner
Partner

Running sum in a Stacked Bar Chart

Dear Community,

 

I am trying to produce a stacked bar chart with a cumulative sum across dates with the customers being the groups :

 

Stevan_Klaas_4-1632058474848.png

 

This is the base data :

Stevan_Klaas_1-1632057819680.png

In Excel obtaining the underlying table is easily done with pivot running sum on "Booking Year Month" :

Stevan_Klaas_5-1632058518618.png

 

However I can't find a use case in the community that does the trick.

 

Below is the nearest solution I found, it cumulates when there is a data at the intersection of dimensions but it doesn't persist the cumulated amount across the data columns.

Stevan_Klaas_3-1632058078412.png

Thanks for any help,

Stevan

 

 

Labels (2)
1 Reply
Stevan_Klaas
Partner
Partner
Author

Found the solution myself :

 

In the measure properties of the bar chart, use the modifier "Accumulation", but make sure that you :

1 - cumulate accros the X-Axis dimension

2 - Set the range to "full" !!

(Strangely by default the range is "Custom" with 6 steps, which would do a rolling accumulation over 6 axis values...)

 

Stevan_Klaas_2-1632588766447.png