Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elizabeth__
Contributor III
Contributor III

Reversing a gauge

Hello all,

I have a gauge-based KPI sheet in my project. My problem is I need the gauges to all "face the same direction" i.e. green always on the right side of the gauge, but for some KPIs, a higher number is better, and for some a lower number is better. 

This is one of the gauges. It is for a scrap %. I played around with subtracting the value and reference lines from 1 to reverse the metric, so higher is better. 

Capture.PNG

Is there a way in the formatting to switch it back to 5.43 in the center of the gauge? 

Is there an extension where you can have exactly three sections designated like in the vanilla chart that has the functionality I'm looking for? The clients specifically want them facing the same way and with three sections.

Thanks,

Elizabeth

Labels (1)
  • gauge

1 Solution

Accepted Solutions
Patrik_Lundblad
Employee
Employee

Something like this?


Gauge.PNG

If so then you could test and 

  • Take the KPI value you have and subtract it by 2 times. (Such as =KPI-2*KPI to get -5.43)
  • Change the format pattern to custom and insert a format pattern that removes the minus sign (#,##0.00;#,##0.00)
  • In range limits you input -100 as min (or -1 in you case of %) and 0 as max
  • Insert your limits and make sure they are negative (like -90 and -70)

Having changed the format pattern the data is negative, but displayed as positive. Not sure if that causes you any other issues.  

Regards,

Patrik.

 

View solution in original post

3 Replies
JustinDallas
Specialist III
Specialist III

You can change where the red, yellow and green appear on the gauge. 

 

GaugeAppearance.png

elizabeth__
Contributor III
Contributor III
Author

Yes, like in the screenshot I did that with this metric on the right. Original gauge is on the left, swapped is on the right.

I switched the green and red areas, and subtracted all my values from 1 to effectively change scrap % to good pieces %. This is confusing for the users where the 94.57% appears -- they are used to seeing a scrap value that is around 5%.

I want to know if with number formatting or by some other means, I can have: 

  • the gauge go from red, to yellow, to green
  • hide the number in the middle of the gauge OR have it display 5.43%

I can achieve the first item by switching the percentage to be good pieces % (94.57%), but that number is not clear to the users.

Patrik_Lundblad
Employee
Employee

Something like this?


Gauge.PNG

If so then you could test and 

  • Take the KPI value you have and subtract it by 2 times. (Such as =KPI-2*KPI to get -5.43)
  • Change the format pattern to custom and insert a format pattern that removes the minus sign (#,##0.00;#,##0.00)
  • In range limits you input -100 as min (or -1 in you case of %) and 0 as max
  • Insert your limits and make sure they are negative (like -90 and -70)

Having changed the format pattern the data is negative, but displayed as positive. Not sure if that causes you any other issues.  

Regards,

Patrik.