First, set up your chart and get a Traffic Guage expression. Then click on Guage Settings. Make sure you uncheck Autowidth Segments, because you want to define your own rules.
Then you need three Segments. Red should be first and have a lower bound of 0. Then Yellow with LB 50. Then Green with LB of 100.
You also want to set the Max to the highest value one dimension can have.
I've attached a simple example. You may need to tweak it to get the correct colors at the end points of each section.
Traffic.qvw 113.1 K
It´s possible. Into Chart properties, go to the combo "Representation" and select the option "traffic light gauge", so click on Gauge Settings and disable the option "Autowith Segments". Input the Min (0) and Max (100 or more), after go the "Segments setup" and settings your colors and "Lower Bound". For the Lower Bound will be the follows:
Red = 0
yellow = 50
green = 100
Remember is the LOWER BOUND
Click on OK.
PD: Sorry mi english, I don't speak very well...
Hi Ricardo, NMiller,
Thanks a lot for your replies !!
I could get the traffic light gauge display in the numerical column in the straight table chart after following the steps you mentioned.
NMiller, sorry i could not open the .qvw file that you sent as i currently have Qlik View 9.0 Personal Edition and it would have used up my 4 attempts and changed the key.
I have one further question. I am trying to display the numerical value in the center of the traffic light gauge. I understand from the various posts in the forums that i need to use "Text in Chart" option in the traffic light gauge properties for this purpose. I tried a lot by using this feature in my traffic light gauge by adding a text using "Text in chart" but i am not successful. Somehow that text just simply disappears next time when i open the traffic light gauge properties and also doesnot show in the traffic light gauge in straight table column.
Any idea where i am going wrong to display text by using "Text in chart" option in Traffic light gauge ? Is there any other way i can see this text inside the traffic light gauge ?
Thanks and Regards