topic How to create accumulated bar chart in QlikView

How to create accumulated bar chart

Wed, 08 Oct 2014 14:10:13 GMT

Hello,

I need to create bar chart for 2014, 2015 and 2016 revenue. I only need to accumulate revenue for each year.

I don't want to create three chart. I want to put them in one chart.

Can you help?

I attached my excel file of this requirement.

Thanks,

Dust

Gysbert_Wassenaar — Wed, 08 Oct 2014 14:23:56 GMT

Create a year field. Use the year field and the month field as dimensions and enable full accumulation for the expression.

See attached example.

Wed, 08 Oct 2014 15:02:41 GMT

Hi Gysbert Wassenaar,

Appreciate your solution.

Looks like we are very close. Do you have a way to show this chart year by year and side by side? Just like I showed on my excel file.

Thanks,

Dust

Gysbert_Wassenaar — Thu, 09 Oct 2014 17:05:17 GMT

That requires a different approach. See attached qvw.

Thu, 09 Oct 2014 19:04:06 GMT

Thank you very much - Wassenaar.

The first solution works. This one is another solution on my question. Very creative.

Your help is greatly appreciated!