topic Accumalation in Pivot Chart in QlikView

Accumalation in Pivot Chart

Thu, 31 Jul 2014 10:43:07 GMT

Hi QlikView experts!

I’ve a problem, but I’m sure you can solve it.

I want to create a pivot chart in with I can see the sales of the selected month (1 to
12) und all sales accumulated from 1 until the selected month.

I have no idea how to make accumulated sales.

I’vesearched the whole World Wide Web, but couldn’t come up with the right
solution. Maybe you have the right answer for me.

See the attached file for details.

Thanks for your help!

MK_QSL — Thu, 31 Jul 2014 10:53:37 GMT

Use below 4 expressions...

=Sum({<Year={'$(=Max(Year))'}>}Sales)

=SUM({<Month = , Year = {'$(=Max(Year))'}, Month = {">=1<=$(=Max(Month))"}>}Sales)

=Sum({<Year={'$(=Max(Year)-1)'}>}Sales)

=SUM({<Month = , Year = {'$(=Max(Year)-1)'}, Month = {">=1<=$(=Max(Month))"}>}Sales)

Thu, 31 Jul 2014 12:04:03 GMT

Thanks a lot! It works perfectly!! Made my day