Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nezuko_kamado
Creator
Creator

Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo()))

I could create a pivot table of monthly accumulated unit sum with rangesum(above(Sum(Unit), 0, RowNo()))

Capture1.PNG

This chart is what I want to get of the grouped by Month with the accumulated unit sum over months, just like the highlighted part.

Capture2.PNG

However, I can’t visualize the highlighted part with a bar chart or a combo chart, and I manually had to sum the total of each month as below in order to  create the graph above.

AccumulatedMonthSum:
Load * inline [ Year, Month, AccumulatedSum
2019,        Jan            ,14
2019,        Feb            ,27
2019,        Mar           ,44
2020,        Jan            ,13
2020,        Feb            ,32
2020,        Mar           ,40
2021,        Jan            ,17
2021,        Feb            ,24
2021,        Mar           ,32
2022,        Jan            ,18
2022,        Feb            ,37
2022,        Mar           ,47];

Without this manual summation, all I could get were as below, which are different from the top graph . 

Capture3.PNG

Capture4.PNG

How can I create the graph on top  without manually calculating the sums?

I tested them with a pseudo data set below, since my original is too large and complicated.

Dat:
load * inline [ Year, Month, Unit
2019, Jan, 2
2019, Jan, 3
2019, Jan, 4
2019, Jan, 5
2019, Feb, 2
2019, Feb, 2
2019, Feb, 1
2019, Feb, 3
2019, Feb, 5
2019, Mar, 6
2019, Mar, 4
2019, Mar, 2
2019, Mar, 5
2020, Jan, 6
2020, Jan, 2
2020, Jan, 2
2020, Jan, 3
2020, Feb, 3
2020, Feb, 4
2020, Feb, 5
2020, Feb, 6
2020, Feb, 1
2020, Mar, 1
2020, Mar, 2
2020, Mar, 2
2020, Mar, 3
2021, Jan, 3
2021, Jan, 4
2021, Jan, 5
2021, Jan, 5
2021, Feb, 2
2021, Feb, 2
2021, Feb, 1
2021, Feb, 2
2021, Mar, 4
2021, Mar, 3
2021, Mar, 1
2022, Jan, 1
2022, Jan, 4
2022, Jan, 6
2022, Jan, 7
2022, Feb, 3
2022, Feb, 7
2022, Feb, 5
2022, Feb, 4
2022, Mar, 2
2022, Mar, 3
2022, Mar, 5
];

Labels (1)
1 Solution

Accepted Solutions
Digvijay_Singh

Did you try chart accumulation property? Looks like it does what is shown as expected output above.

Digvijay_Singh_0-1643672542762.png

 

View solution in original post

1 Reply
Digvijay_Singh

Did you try chart accumulation property? Looks like it does what is shown as expected output above.

Digvijay_Singh_0-1643672542762.png