Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

View solution in original post

vikasmahajan
Champion
Champion

Can u share demo application for the same

Thanks

Vikas