7 Replies Latest reply: Apr 19, 2016 11:36 AM by R L RSS

    Use full accumulation in a calculation

      Hi Experts,


      New to Qlikview. I wanted to use running totals using full accumulation based on Dimensions and use this column in another column expression but its using the original values. Based on some suggestions from the community I used RangeSum but it's not working as expected.

      [Cum Rec Qty] = Rangesum(above(total Sum(rec_qty),0,rowno(total)))

      Please see the screenshot. [Cum Rec Qty] should be running total of Receipts group by <cc_edate, plant, material> that is correctly calculated in column [CRqty] with Full Accumulation. I want to use [Cum Rec Qty] in another expression.

      Thanks in advance for your help!