topic Re: Using traffic light style gauge based on text value in QlikView

Using traffic light style gauge based on text value

Thu, 03 Jan 2013 10:16:39 GMT

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.

Re: Using traffic light style gauge based on text value

Gysbert_Wassenaar — Thu, 03 Jan 2013 10:30:41 GMT

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.