Using traffic light style gauge based on text value

[#1]

Hello and happy new year,

I just started with QV and after browsing the web for a while I m still stuck with what seems to be a basic function.

I m using the traffic light style gauge in QV 11.0

My dashboard is about projects and I would like to see a green light if the project is ON TIME / orange for SHORTLY DELAYED / and red for LATE

How do I set that up ???

In the Presentation tab ? in the Expression tab ?

Thanks for your help.

[Gysbert_Wassenaar · Accepted solution]

You could use the match function to translate the text value to a number and set the boundaries of the traffic light accordingly.

match( expresssionhere , 'ON TIME','SHORTLY DELAYED','LATE')

If expressionhere is ON TIME the match function will return 1, if it's LATE it will return 3, etc. expressionhere can be a field or an expression used to calculate your text value.