Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pipuindia99
Contributor II

Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Is there any better idea instead of using a Bar chart to show Budget or Actual values?

8 Replies

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Different yes, better(simpler), no.

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

That depends on what your real intent is. If you really want to show Budget or Actual amounts, you can use line graphs as well to indicate trends. But for comparisons of Budget vs. Actuals, a bar chart is most intuitive. And use a mixed line/bar chart to show Budget & Actuals (2 bars for every dimension value) and on top of that a line/symbol chart that indicates the difference between the two in %.

YMMV.

Peter

pipuindia99
Contributor II

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Thanks Peter... It really helps me to create it

galax_allu
Valued Contributor

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Stephen Few" bullet chart

pipuindia99
Contributor II

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

I am not getting you what you are trying to say...

galax_allu
Valued Contributor

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Hi,

chart will be like this ..

galax_allu
Valued Contributor

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Hi ,

I have attached bullet chart.

Please let me know , if it helps ....

pipuindia99
Contributor II

Re: Is there any better idea instead of using a Bar chart to show Budget or Actual values?

Still I am not clear for what you are using this chart. I am not sure whether it will be helpful to show the difference.

Community Browser