topic Re: Values in Gauge Chart in QlikView

Values in Gauge Chart

Wed, 08 Apr 2015 13:49:46 GMT

Hi there,

Is there a way for me to display values on a gauge chart? Not only as "Text in chart", but to move along side the needle of the gauge chart if the value changes?

Can anyone assist me?

Regards,

Qanitah

Re: Values in Gauge Chart

oknotsen — Thu, 09 Apr 2015 09:33:53 GMT

I would be happy to be proven wrong, but this is (as far as I know) not possible.

Re: Values in Gauge Chart

Thu, 09 Apr 2015 11:45:36 GMT

Would've been great. I'll still look into it and see if I can find some other way.

Thank You.

Re: Values in Gauge Chart

Thu, 09 Apr 2015 11:55:27 GMT

can you explain in more details please.

what i get it from your question is ( you need display the value like i need the margin of my profit in this year or the current selection that appear in your Gauge )?! right or not .

if it like this it is possible.

Ahmad Kastero

Re: Values in Gauge Chart

Fri, 10 Apr 2015 07:44:43 GMT

Correct. My issue is a however based on the appearance of the gauge. I would like the value being displayed to follow the needle when it moves. So, if another value is selected, the needle will move and the value must move with it.

Qanitah

Re: Values in Gauge Chart

Agis-Kalogiannis — Fri, 10 Apr 2015 08:12:20 GMT

What you can do instead, and this looks quite nice actually, is to add text in chart and move the number inside the chart

Re: Values in Gauge Chart

Fri, 10 Apr 2015 08:43:10 GMT

It does look quite nice. My colleague showed that way to me as well.

Thank You.

Re: Values in Gauge Chart

Agis-Kalogiannis — Fri, 10 Apr 2015 12:22:42 GMT

Glad I could help 🙂

Could you please mark the answer as Helpful or Correct so as to close the discussion?

Thanks.

Agis

Re: Values in Gauge Chart

Sun, 12 Apr 2015 05:49:45 GMT

so , you can do it like this , go the Gauge chart and right click on it then properties and after that go to presentation Tab you will find (Text in chart ) pres add and you can put any Expression you need it will appear like

( =Sum[Total Amount]) .

try it and it will be work .

Best Regards .

Ahmad Kastero

Re: Values in Gauge Chart

oknotsen — Sun, 12 Apr 2015 17:48:15 GMT

Hi question was "not as Text In Chart" .

Anyway,

If you want to have the text follow the needle, you probably have to make a custom object.

You could ask yourself if that amount of work is worth the trouble.

Re: Values in Gauge Chart

Mon, 13 Apr 2015 05:19:09 GMT

yes is not a text in the chart but the text in the chart not only for typing the text but you can also put anything you need like what i explain before ( =Sum[Total Amount]) and this value will change as per your filter , so i thing this is the way to put any changeable value in your chart else the text & using the variable .

so i think you agree with me okg .

Re: Values in Gauge Chart

oknotsen — Mon, 13 Apr 2015 11:36:30 GMT

No offence intended, but I thought the OP wanted to have the number visibly move with the needle (having the number stay near the needle).

However, if the OP only wanted to have the calculation follow his selection, than sure your solution would be it.

Re: Values in Gauge Chart

Mon, 13 Apr 2015 12:25:54 GMT

but even if he need a number move or change with the need or selection on any filter directly will change as per what we select also he can add more than one expressions , that what i suggest but if any one find another solutions for this issues tell us .

thanks for all

Ahmad Kastero

Re: Values in Gauge Chart

Tue, 14 Apr 2015 05:26:05 GMT

if there is a correct answer , could you please do it as a correct .

thanks

Re: Values in Gauge Chart

ankitaag — Tue, 14 Apr 2015 05:53:56 GMT

Hello Qanitah,

You directly cannot show the expression value in the Gauge chart other than showing it as a text in chart or a text box.

Thanks and Regards,

Ankita

Re: Values in Gauge Chart

Tue, 14 Apr 2015 06:04:39 GMT

thank you AnkitaAg what i know this is the way to do it and also i did it before .

Re: Values in Gauge Chart

Tue, 14 Apr 2015 13:38:39 GMT

Hi all,

Thank you, I appreciate all the help I can get. okg‌ was right in that I did want the number to visibly move with the needle. However, as I am pressed for time for this model I settled for showing it as a text in chart kastero.ahmad‌ I will have to do further research in my spare about making a custom object.

Thank You for all the help and responses.

Regards,

Qanitah