topic Re: Traffic Light Gauge in QlikView

Traffic Light Gauge

Mon, 17 Mar 2014 18:18:50 GMT

Hi,

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?

Thanks, Simky

Re: Traffic Light Gauge

Gysbert_Wassenaar — Mon, 17 Mar 2014 18:38:51 GMT

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.

Re: Traffic Light Gauge

Mon, 17 Mar 2014 18:43:22 GMT

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.

Thanks

Re: Traffic Light Gauge

Mon, 17 Mar 2014 18:51:41 GMT

It worked. Thanks for the solution, I was not aware of Gauge logic.

Re: Traffic Light Gauge

jerem1234 — Mon, 17 Mar 2014 18:52:04 GMT

To demonstrate Gysbert Wassenaar's and Ajay Prabhakaran's solutions, here is an example qvw you can check out.

Hope this helps!