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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

May be this

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

Anonymous
Not applicable
Author

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
sunny_talwar

Try this

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

Anonymous
Not applicable
Author

I ended up using

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