Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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