topic Fixed budget value question in QlikView

Fixed budget value question

Thu, 17 Jan 2013 10:53:42 GMT

I have a bit of a newbie question. I am trying to create a Combo chart or a Line chart with monthly sales, together with a budget line that will run over the chart as a comparison line to see if we reach our budget.

I have created the chart with our monthly sales per year, but how do I implement a line with a fixed budget sum that should be the same for every month, running over the entire year?

I have tried to add a new expression in a Combo chart that will represent the fixed budget sum, but I am not sure which definition the expression is supposed to have. To make things easier while helping me, lets say that the fixed sum I would like to implement has the value of 10000.

I am thankful for all the help i can get.

Re: Fixed budget value question

mikecrengland — Thu, 17 Jan 2013 16:59:15 GMT

On the Presentation tab, you can add a Reference Line.

Re: Fixed budget value question

mazacini — Thu, 17 Jan 2013 20:16:54 GMT

As long as the sum is fixed for each month, then, for value 10000, just enter 10000 in the definition for your budget expression.

Re: Fixed budget value question

Fri, 18 Jan 2013 13:55:57 GMT

Thank you for the help. That´s a very easy solution that will do the trick.