Gauge Chart Settings

[Anonymous]

I would like to show the values around the chart as 3K, 6K, 9K, 12K and 15K while still being able to show the actual value of the Sales when hovering over the chart needle (300). 

I have tried several number format changes without the desired result. 

I have attached a sample QlikView application showing this chart. 

Is what I am trying to do possible in QlikView??

Thanks for your help.

Ed T.

[Gysbert_Wassenaar · Accepted solution]

I don't think it's possible without putting two gauge charts on top of each other. It's far easier to add a Text in Chart object to the gauge chart. See attached qvw.

[Anonymous]

Thanks, Gysbert.  That seems to work.

One quick question - What does the "DUAL('Moooo', ....." function do?  I have not seen that before.

Thanks again,

Ed

[Gysbert_Wassenaar]

Ah, ehm, ignore that. I forgot to remove something I tried but didn't work.

The dual function is used to give a value both a numeric value and a text value for display. You can find a more detailed description and an example in the help file.