topic Reference Lines in the Speedometer (Guage) Chart in QlikView

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 09:21:40 GMT

Dear All,

I wanted to use reference lines in the speedometer chart. I can use the same with other type of guage charts, however QV doesn't show the reference lines for the Speedometer chart. I had read the QV documentation and it says that we can use reference lines for Circular Guage Charts ( I am assuming that the ciruclar guage chart is the speedometer chart, please correct me if I am wrong). I had pasted the below text from the documentation and you can refer the same from Page 198 and Book III.

In the Reference Lines group you can define reference lines intersecting
the gauge background area at a given value. Reference lines
are only available in circular and linear style gauges. A list shows all
existing reference lines in the chart.

Thanks in advance. I'll look forward for some expert suggestions.

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 09:35:11 GMT

Keep in mind that in the gauge chart you have no dimensions, so if your reference line expression is producing multiple values, then they cannot be shown. In other words make sure that your reference line expression either returns one value, or you enable trellis on your dimension(s).

Reference Lines in the Speedometer (Guage) Chart

matt_crowther — Wed, 30 Mar 2011 09:38:31 GMT

DV,

I've created something similar to what you're after (I think) in my 'Server Monitoring' .qvw:

You can download it via: http://community.qlik.com/media/p/142911.aspx

There are several other non-standard 'gauge' charts in there so have a poke around.

Hope that helps,

Matt - Visual Analytics Ltd

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 09:53:06 GMT

Matt - I had just downloaded the document and it looks awesome. I am looking for the similar solution and thanks for sharing the idea. I understand that you had used multiple charts and placed on top of the original chart and used transperancy. This is very good technique.

However, I am looking to add a reference line to the chart and not the additional needle. Please can you let me know if you have used this approach in the past?

Thanks again for you time.

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 09:59:53 GMT

Yes, you can do that. But you will have to follow the instructions that I gave you in my previous post.

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 10:23:31 GMT

Iassen - My expression returns a scalar value in the reference line. However, it does not seem to like it on the speedometer chart. I mean it does not show up in the speedometer chart and shows in the types of guage charts. I am not using any dimensions on this chart.

Please can you post an example if possible, that would be really helpful. Many thanks again for your time & patience with me.

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 10:37:50 GMT

here you go...

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 11:03:15 GMT

Iassen - Thank you for sharing the example. I can't see the reference line on the chart. I mean if you change the chart type you can see the blue color reference line. However on the speedometer guage chart it does not show the line. I am followin the same approach as yours and having problems to show the reference line on the speedometer chart.

I hope I am making sense in explaining the issue. Please help!

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Anonymous — Wed, 30 Mar 2011 11:06:25 GMT

Maybe you are using an older Qlikview version?
I am using QV10 and it does show on the guage charts also.

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 11:10:33 GMT

Same here...

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 11:11:15 GMT

Dennis - Thank you for the update. I am using Version 9 SR3, that could be the reason.

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 11:19:25 GMT

Yes, seems this way. I just checked it in 9 and it's not showing.

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 11:24:10 GMT

Iassen, Dennis & Matt - A big thanks for all your time & knowledge. It's disappointing to know that its the bug in the version 9 but can't do much now.

Have a good day ahead.

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 11:28:27 GMT

Sorry I couldn't help mate. Thanx for the points!

Reference Lines in the Speedometer (Guage) Chart

IAMDV — Wed, 30 Mar 2011 11:34:36 GMT

Iassen - I think you did help me! All of you deserve the points...

Can I add you as a friend?

Cheers - DV

Reference Lines in the Speedometer (Guage) Chart

Wed, 30 Mar 2011 11:53:37 GMT

Good!

Try me... 🙂