Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)