Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.