topic Values in Speedometer in QlikView

Values in Speedometer

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have speedometer, which is showing correct values. Only we need to show the Intermediate values in chart. Like below:

1. We need to show values like 0,0.2,0.4,0.6,0.8 and 1.

How to show this.

2. We need to show the Title as above. XX % Service Level of YYY

Please help.

Thanks,

Sarif

adamdavi3s — Mon, 27 Feb 2017 07:59:32 GMT

This is where you add the units:

To make a dynamic title you just need to do a formula, I've attached an example for you

mhmmd_srf — Mon, 27 Feb 2017 09:45:55 GMT

cant we make this as 20% instead of 20.00 %.

Though the measure would show as two decimal.

Please help.

Thanks,

Sarif

adamdavi3s — Mon, 27 Feb 2017 09:53:56 GMT

Hi Sarif,

If you mean the title then yes just adjust the formula

=num((sum(BudgetedHours-HoursWorked)/sum(HoursWorked))*70,'0%')&' variance for hours'

mhmmd_srf — Mon, 27 Feb 2017 10:47:54 GMT

not title sir...the reference Number like 20%, 40%, 60%, 80% etc...

How can I do this.

Please help.

Thanks,

Sarif

adamdavi3s — Mon, 27 Feb 2017 10:53:31 GMT

Just change it on the 'Number' tab to be an integer