topic Re: Stacked Bar Chart - Actual vs Budget in QlikView

Stacked Bar Chart - Actual vs Budget

jmonroe918 — Thu, 08 Oct 2015 00:06:01 GMT

I am trying to create a stacked bar chart that compares costs between Actual and Budget for different accounts. The file attach has a chart that currently adds the two together and creates a bar that is the sum of the two. I would like to have the Budget and Actual both start at the 0 point and show the two bars with the Actual on top (or overlaying) of the Budget (with both data labels appearing).

I need to show the progress of the Actual as it approaches the Budget total.Is there a method to using Grouped bar charts that are brought together, or is stacked the way to go?

Thanks

Jeff

Re: Stacked Bar Chart - Actual vs Budget

Clever_Anjos — Thu, 08 Oct 2015 01:20:29 GMT

Not so sure if this is what you want

Re: Stacked Bar Chart - Actual vs Budget

settu_periasamy — Thu, 08 Oct 2015 01:52:34 GMT

Hi Jeff,

Do you Want like the below screen shot? if So, Chart Properties -> Style -> SubType -> Grouped..

Re: Stacked Bar Chart - Actual vs Budget

jmonroe918 — Thu, 08 Oct 2015 14:26:47 GMT

Clever:

Almost. See below (this is a mock-up).

Note that the overall total length of each bar is the Budget amount (green) and the Actual is "overlayed" over the Budget, both starting at 0. It's to show the amount spent verse what was budgeted.

Thanks.

Jeff

Re: Stacked Bar Chart - Actual vs Budget

jmonroe918 — Thu, 08 Oct 2015 14:27:41 GMT

Setu:

No, this is not what I wanted. I need it stacked, but not a total of Budget and Actual.

Thanks.

Jeff

Re: Stacked Bar Chart - Actual vs Budget

rubenmarin — Thu, 08 Oct 2015 14:42:23 GMT

Hi Jeff, please check attached document.

Re: Stacked Bar Chart - Actual vs Budget

rubenmarin — Thu, 08 Oct 2015 14:46:04 GMT

Looking in detail, Clever solution worked, just be aware than in your uploaded qvw Actual filters by 'P*_Bud_15' and Budget filters by 'P*_Act_15'.

So values are inverted.

Re: Stacked Bar Chart - Actual vs Budget

Thu, 08 Oct 2015 14:47:49 GMT

Jeff

using the bar charts as grouped is really the best way to show the relationship between budget and actual

when the bars are stacked it does not relay the message as well.

Another option would be to calculate a percent of actual compared to budget and have budget be a line at zero - use a line chart to show each dimension compares to budget

Re: Stacked Bar Chart - Actual vs Budget

Clever_Anjos — Thu, 08 Oct 2015 14:53:20 GMT

Please check if fits your needs

Re: Stacked Bar Chart - Actual vs Budget

Thu, 08 Oct 2015 14:56:39 GMT

attached is a vizual example of what I was referring to

Re: Stacked Bar Chart - Actual vs Budget

jmonroe918 — Thu, 08 Oct 2015 14:57:34 GMT

Ruben:

Is there any way to show the Actual data labels?

Jeff

Re: Stacked Bar Chart - Actual vs Budget

rubenmarin — Thu, 08 Oct 2015 14:59:15 GMT

Yes, look attached document by Clever below this post

Re: Stacked Bar Chart - Actual vs Budget

qlikviewwizard — Thu, 08 Oct 2015 14:59:26 GMT

Hi,

Check this application. Hope this will help you.