Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi partners.
I would like to make the amount accumulated in my table, however I would like
that would make the accumulations of the months by the correct status.
The expression I use is: = SUM (VALUE) and I choose the option to accumulate 12 last steps
The expression value is = SUM (VALUE) but without the accumulate option checked (this is correct)
I just need some help for the accumulated value
My idea is Month of February - Status (ACTUAL) = It must add the previous month (Jan) that has the Current Status with the value of the Month of February that has the Current Status, and so for all months and status.
The result I got is this
Thank you for your help
Nicolas
Please refer RangeSum() function
Hi Vijeta, thanks for the comment.
I will study about the RangeSum function and try to apply it in my expression
Thank you
Try accumulate option in the expression or use below
rangesum(above(Sum(Value),0,RowNo()))
basically - rangesum - sums up a range of values
above - gives values of sum(value) from row #1 (0 in qlik) to current row