Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
fsilva1
Contributor II
Contributor II

Cumulative Sum by year - Sorting AGGR(RANGESUM(ABOVE()))

Hi guys,

I'm trying to do the cumulative by year, but when start a new year, is continue cumulating but I want to start a new cumulative when a new year start.

my expression:

aggr(rangesum(above(Sum( value),1,RowNo())),(year_month,NUMERIC))

I dont understand why, jan 2022 is not start a new cumulative, its keeping cumlating. Someome please help me?

The expected result is that in jan 2022, the value to third column be 996766,42 starting a new cumulative values

@sunny_talwar please help me

fsilva1_0-1655313102264.png

 

Labels (5)
2 Replies
vinieme12
Champion III
Champion III

try as below

 

=aggr(rangesum(Above(sum(value),0,rowno())),YEARFIELD,YEARMONTHFIELD)

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
fsilva1
Contributor II
Contributor II
Author

First of all thank you for your answer..

But not working

aggr(rangesum(below(sum({<period-={'$(=min({1}period))'}>}[value]),0,rowno())),period,period_2)