Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Monthly accumulated values

Hi all,

   I've been trying to put up a chart with the accumulated values by month and I've been wondering if there's any expression to do this for me, so I don't need to place this info in the datasources. Ok, in more detail now. I have a table with the following info:

  • Month;
  • Product Name;
  • Sales Value.

   What I want in the end, is a chart where I can see the total sales value accumulated by month. Meaning, in the first month is the value of the sales themselves, the second month the sales of the current month plus the ones of the month before, and so forth. In the end this chart should look something like the one in attach.

   Does someone know of any function to do this automatically?

Thanks,

André

1 Solution

Accepted Solutions
Not applicable

Monthly accumulated values

Hi Andre,

there is an accumulation option within the charts themselves that you can use, under the expressions tab at the bottom left you will see the option for full accumulation or a number of steps (months in your case) back

hope this helps

thanks

Joe

2 Replies
Not applicable

Monthly accumulated values

Hi Andre,

there is an accumulation option within the charts themselves that you can use, under the expressions tab at the bottom left you will see the option for full accumulation or a number of steps (months in your case) back

hope this helps

thanks

Joe

vikasmahajan
Esteemed Contributor

Re: Monthly accumulated values

Can u share demo application for the same

Thanks

Vikas