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: 
harjedalskok
Creator
Creator

Accumulation with expression.

Hi im kinda lost here,

I would like to create a expression that accumulate like the attached table.

Rangesum(above(Diff, ), sum(diff)))

 

WeekBudgetSalesDiffAck
2020-01901 143355 096-546 047-546 047
2020-021 802 2862 835 1141 032 829486 782
2020-032 252 8572 538 308285 451772 233
2020-042 252 8571 347 297-905 560-133 328
2020-052 252 8571 840 274-412 583-545 910
1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hello!

Accumulate expression will be:

RangeSum( Above(  Diff  ,0  ,RowNo() ))

max_value.jpg

View solution in original post

1 Reply
Sergey_Shuklin
Specialist
Specialist

Hello!

Accumulate expression will be:

RangeSum( Above(  Diff  ,0  ,RowNo() ))

max_value.jpg