Replicate the Full Accumulation QV function with Data Analysis

[#1]

Hello,

I would like to use the result produced by the full accumulation QV functionality as part of another formula (please see attachment for clarification). I have tried to access the monthly cell values with the COLUMN() function but it does not return the accumulated value. Is there anyway to accomplish this using set analysis or Qlikview functions?

Thanks in advance

[settu_periasamy]

Hi,

May be try this..

=Rangesum(Above(TOTAL sum(YourExpression),0,rowno(TOTAL)))

Accumulation : No Accumulation

[sunny_talwar · Accepted solution]

You can do full accumulation using this general formula:

RangeSum(Above(YourExpression, 0, RowNo()))

[#4]

Thank you, this is exactly what I was after