topic Present actual vs budget in QlikView

Present actual vs budget

Wed, 14 Dec 2011 09:44:06 GMT

Hi all,

I have 5 factories, all have a score on 20 subjects. The maximum score on each of the 20 subjects is 5, but the "budgetted" score can be lower than 5. I have created a bar chart with dimension "subjects" and expression "Only([Score])" which gives me an overview of how things are for each factory. However, this bar chart does not include how far each factory is away from budget.

Reference lines don't seem to work, because the budget is different for each subject, or am I wrong here?

Thanks for you help!

Kind regards,

Stijn

Present actual vs budget

Wed, 14 Dec 2011 09:55:52 GMT

Hi,

Can u attach yur qvw file that will be helpful

Thanks

Vivek

Present actual vs budget

Wed, 14 Dec 2011 09:58:39 GMT

I've added the file. Please note that I'm a personal user

Thanks for your quick reply!

Present actual vs budget

Wed, 14 Dec 2011 10:10:30 GMT

Hi,

I am not able to find bar chart you have created

Thanks

Vivek

Present actual vs budget

Wed, 14 Dec 2011 10:19:25 GMT

Can you see it now?

Present actual vs budget

Wed, 14 Dec 2011 10:31:10 GMT

Hi,

You can use a line chart and add another expression for budget .So you can easily identify the diffrence

Thanks

Vivek

Present actual vs budget

Wed, 14 Dec 2011 10:42:22 GMT

That's definitely a possiblity, thanks for that! However, is it possible to have some kind of Gauge chart to visualize this? So instead of the bars, I get a Gauge chart for each subject. In other words: a bar chart, but with Gauge charts instead of bars.

Thanks a lot for your replies!

Present actual vs budget

Wed, 14 Dec 2011 10:50:00 GMT

Hi,

This can be possible in straight or Pivot table where in Expression Tab u have option to create gauge charts for each subject ,under representation(Display Options).

Thanks

Vivek

Re: Present actual vs budget

Wed, 14 Dec 2011 11:03:54 GMT

Great! It works superb when the budgetted value is always equal to the same number. But when it differs for each option, Qlikview gives an error: "Bad Min or Max in Gauge"... I've added an updated qvw.

Edit: The budgetted value is always greater than the As is value, so that can't be the problem

Thanks!