topic Re: Multi-colored Accumulative Bar Chart in QlikView

Multi-colored Accumulative Bar Chart

Tue, 25 Aug 2015 23:52:24 GMT

Hello,

I am trying to create a chart similar to below:

I have values accruing quarter over quarter with a yearly target. Having issues how to recreate this in QlikView. I am also open to ideas on if there is a better way to visualize the data.

Thanks in advance!

-Jason

Re: Multi-colored Accumulative Bar Chart

sinanozdemir — Wed, 26 Aug 2015 00:25:58 GMT

Hi Jason,

Something similar to this:

I am attaching the qvw in case you like the example.

Hope this helps

Re: Multi-colored Accumulative Bar Chart

jagan — Wed, 26 Aug 2015 03:12:03 GMT

Hi Jason,

If you attach sample then it will be easier to understand the data and possible to provide the effective solution. Are you using two dimensions in the chart? If you are using two dimensions in the chart then you can select the Stacked option in Style tab.

Hope this helps you.

Regards,

Jagan.

Re: Multi-colored Accumulative Bar Chart

Anonymous — Wed, 26 Aug 2015 09:57:38 GMT

I attached an example.... let me know!

Re: Multi-colored Accumulative Bar Chart

Wed, 26 Aug 2015 20:27:40 GMT

This is perfect. Thanks, you rock!!

Re: Multi-colored Accumulative Bar Chart

Wed, 26 Aug 2015 20:28:39 GMT

Hi Sinan,

This is close but i only have one dimension in this case. The solution provided by Elena888 below is exactly what I needed. Thank you!

-Jason

Re: Multi-colored Accumulative Bar Chart

Wed, 26 Aug 2015 20:29:15 GMT

Thanks Jagan, the solution provided by Elana888 below solved my issue.

Cheers!

-Jason