topic Gauge Chart in QlikView

Gauge Chart

Mon, 27 Feb 2012 07:54:35 GMT

Hi,

Can somebody please help me to format the actual result, which is visible in the Chart Title window, in percentage. I have the scale of the gauge chart in percentage but don't manage to have the actual result in percentage. Or is there a way to present the actual result next to the chart?

Thanks and Krgds,

Lennart

Gauge Chart

CELAMBARASAN — Mon, 27 Feb 2012 08:38:45 GMT

Hi,

Use the expression you have used in the title like

=Num(Expression,'###.##%')

Its better to use it in the Text in Chart option.

Properties-->Presentation tab

Hope it helps

Celambarasan

Re: Gauge Chart

Mon, 27 Feb 2012 08:52:34 GMT

Hi Celambarasan,

This worked great, thanks a lot for your help.

By the way, would you know how I could restrict the values being shown to only a certain time period? Right now the value being shown is the accumulated values of all of 2011 and also Jan-2012. But I would like this gauge chart to only show the values for 2012.

Thanks again for your help, most appreciated!

Krgds,

Lennart

Gauge Chart

CELAMBARASAN — Mon, 27 Feb 2012 09:21:11 GMT

Hi,

What expression are you using?

You expression may be like Sum({<Year={'$(=Max(Year))'}>} Sales)

Add the bold part to your expression.

Celambarasan

Re: Gauge Chart

Mon, 27 Feb 2012 09:50:52 GMT

Hi Celambarasan,

And thanks again, your suggested script worked absolutely perfectly!

Thanks and Krgds,

Lennart

Re: Gauge Chart

CELAMBARASAN — Mon, 27 Feb 2012 09:59:10 GMT

Hi,

Close this discussion by mark it as correct answer which will help others who looking for same type of solution.

Celambarasan

Re: Gauge Chart

Mon, 27 Feb 2012 10:13:06 GMT

No problem, but how do I mark it as a correct answer…. Thanks!

Re: Gauge Chart

CELAMBARASAN — Mon, 27 Feb 2012 10:18:28 GMT

Hi,

On my post you seen correct answer and helpful answer button.

Celambarasan

Re: Gauge Chart

Mon, 27 Feb 2012 10:32:55 GMT

Hi,

I’m afraid I don’t see any such buttons….don’t know whether it has anything to do with my settings or whether the webpage is experiencing any problems.