Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
m_torabi
Partner - Contributor
Partner - Contributor

cumulative sum in the graph

Using this formula, I can obtain commutative sum for each category:

=Rangesum( above(  sum( {$<Month=>} Amount),0,RowNo()))


The problem is, when I use the same formula in a chart, the result obtained is not the same.

In the screenshot below, Graph is the clone of "Table 1", however it doesn't reflect the same values:

sc4.PNG


My desired graph is the one with the same value as the Table 1 's "Cumulative sum" column for each category.

The problem is RowNo() function has different behavior when used inside the graph rather than as a script.

I would like to apply the solution without using the "Full accumulation" option.

1 Reply
WIPER
Partner - Contributor
Partner - Contributor

use this in frontend for your desire result-

aggr(RangeSum(Above((Sum(Amount)),0,RowNo())),Year,Month)