Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Gauge Chart

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

Tags (1)
8 Replies

Gauge Chart

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

Not applicable

Re: Gauge Chart

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

Hi,

     What expression are you using?

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

     Add the bold part to your expression.

Celambarasan

Not applicable

Re: Gauge Chart

Hi Celambarasan,

And thanks again, your suggested script worked absolutely perfectly!

Thanks and Krgds,

Lennart

Re: Gauge Chart

Hi,

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

Celambarasan

Not applicable

Re: Gauge Chart

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

Re: Gauge Chart

Hi,

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

Celambarasan

Not applicable

Re: Gauge Chart

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.

/L