topic Accumulation until max Date with dimension Month in QlikView

Accumulation until max Date with dimension Month

michael_maeuser — Tue, 30 Apr 2013 12:03:03 GMT

Hi,

I have a Pivot Table with Dimension category and Month.

If I select e.g. year=2013 and i look at April, I need to sum all values until April 2013 (accumulation until the max Date of the Month).

Attached is a sample. I just don´t get it...

Thanks for helping.

Michael

Re: Accumulation until max Date with dimension Month

orital81 — Tue, 30 Apr 2013 12:33:14 GMT

Hi, You can use the Full Accumulated option

but for this you will need to change to straight table.

See attached qvw.

Ori

Re: Accumulation until max Date with dimension Month

michael_maeuser — Tue, 30 Apr 2013 12:36:41 GMT

No sorry if forgot to mention that this part only refers to some categories (i refer with an if statement). and for all other categories it willt not be accumulated

Re: Accumulation until max Date with dimension Month

orital81 — Tue, 30 Apr 2013 12:52:23 GMT

You can use RangeSum as folowing:

rangesum(above(sum({<Date={"<=$(vTest)"}, Category = {'A'}>} Amount),0,RowNo()))

See attached

Re: Accumulation until max Date with dimension Month

michael_maeuser — Tue, 30 Apr 2013 12:59:16 GMT

thanks so far, but it´s only working in straight table. i need that view with the month horizontal because i have many categories