Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ajaymehtaece
New Contributor

Running Total not working

Hello everyone,

I am trying to calculate running total in the last column using formulae(Aggr(RangeSum (above(sum([ABS Error EA (Shipment)]),0,RowNo())),[Product Level Value])

But unfortunately its throwing some garbage value in few of the rows. Kindly suggest me the proper solution.I am trying from long time but not getting the solution.

Thanks in advance.

Running total.PNG

Tags (1)
1 Solution

Accepted Solutions

Re: Running Total not working

How about if you try this

RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0, RowNo(TOTAL)))

View solution in original post

1 Reply

Re: Running Total not working

How about if you try this

RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0, RowNo(TOTAL)))

View solution in original post