topic Re: Accumulated Value with Filter in QlikView

Accumulated Value with Filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Accumulated Value with Filter

vijetas42 — Thu, 01 Nov 2018 10:17:15 GMT

Please refer RangeSum() function

Re: Accumulated Value with Filter

Anonymous — Thu, 01 Nov 2018 10:41:32 GMT

Hi Vijeta, thanks for the comment.

I will study about the RangeSum function and try to apply it in my expression

Thank you

Re: Accumulated Value with Filter

dplr-rn — Thu, 01 Nov 2018 12:49:55 GMT

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