Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to create traffic light (red/green) for a percentage column.
I used Representation > Traffic Light Gauge option. I am getting red for values less than 0, however not able to create green sign for positive value. Can anyone help me seeing the screenshot?
Go to Solution.
The Min and Max settings are for the entire gauge, not for a single segment. So you'll have to change the Max setting so positive values can be shown. Next add another segment for the positive values.
You have to click Add and add another segment. Then for the first one set the Lower bound to -1 and for the second set it to 0.
Then change gauge setting max to 1.
This way -1 to 0 will be red and 0 to 1 will be green.
It worked. Thanks for the solution, I was not aware of Gauge logic.
To demonstrate Gysbert Wassenaar's and Ajay Prabhakaran's solutions, here is an example qvw you can check out.
Hope this helps!