Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

asadr26e
New Contributor II

Need help with running sum

  Hey guys,

I am having issues  with this  I need to be able to  do this on a pivot chart as well as backend  script .  The last column adds the staff on site .  and sorts it by Arrival order   and groups by id.  Any help would be appreciated.  Thank you so much!

IDArrival_OrderStaffOnsiteRunning Sum needed Column
10-0000313433
10-0000313536
10-0000401333
10-0000401436
10-2093202144
10-20932022610
10-20932024919
10-20932025221
4 Replies

Re: Need help with running sum

May be this

RangeSum(Above(Sum(StaffOnsite), 0, RowNo()))

asadr26e
New Contributor II

Re: Need help with running sum

Thanks, however when I add a column to this it stops the running total.  is there a way I can use the rangesum in script and pull from there?    i need it to reset when inci_no changes and arrival order rolls back to 1. 

IDunitArrival_OrderStaffOnsiteRunning Sum needed Column
10-00003132w433
10-0000313e31536
10-0000401d2333
10-0000401e2436
10-209320241144
10-2093202242610
10-2093202xw24919
10-2093202xss5221

Re: Need help with running sum

Try this

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, RowNo(TOTAL)))

asadr26e
New Contributor II

Re: Need help with running sum

I ended up using

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, arrival_order))   and that worked.. Thank you

Community Browser