topic Setting a Gauge without fomulas in QlikView

Setting a Gauge without fomulas

Fri, 11 Feb 2011 15:04:56 GMT

Is there a way to display two points on a gauge without a formula? I have a Year to Date Actual Sales figure and a Year to Date Budget figure and I want the needle to display the actual sales point and the budget number end point (most right point).

Additionally, If there is a way to easily show the percent of Actual to budget on the gauge, that would work as well.

Thanx

Setting a Gauge without fomulas

Anonymous — Sat, 12 Feb 2011 12:23:33 GMT

I don't know what you mean with "without fomulas" but this is how it works.

For making a simple gauge you need (at least) 2 values. 1 is the needle the other is background.

You set your needle as an expression
You set your background in the presentation tab at the min/max gauge setting.

For example: Expression = Sum(sales)
Max Gauge (Budget*2)

If you have 2 segments your budget will be in the middle of the gauge.

I hope this helps