Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Accumalation in Pivot Chart

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!

1 Solution

Accepted Solutions

Re: Accumalation in Pivot Chart

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)

2 Replies

Re: Accumalation in Pivot Chart

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)

Not applicable

Re: Accumalation in Pivot Chart

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

Community Browser