Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)
Thanks a lot! It works perfectly!! Made my day