topic Creating Gauge chart (Trafficlight chart) in QlikView

Creating Gauge chart (Trafficlight chart)

thanhphongle — Wed, 13 Jul 2016 08:30:00 GMT

Hello Community,

I m not really good in creating gauge charts especially creating a traffic light chart (only 1 light). I dont know exactly what I have to put in as values in the properties of my chart. I hope anyone can help me.

This is my Database:

Rent.Nr	Present Value	Present Value Limit
1001	45%	90%
1001	76%	90%
1002	41%	90%
1002	32%	90%
1003	78%	90%
1003	89%	90%
1004	90%	90%
1005	120%	90%
1006	115%	90%
1007	101%	90%
1007	95%	90%
1007	77%	90%

My Dimension is Rent.Nr

My expression is AVG([Present Value])

What I exactly want QV to return is:

If( AVG([Present Value])<0.9, show me a green light, else show me red light).

See my attached QV file.

Re: Creating Gauge chart (Trafficlight chart)

sivasiri99 — Wed, 13 Jul 2016 08:38:47 GMT

Hi Thanh,

Try This it may help you

highlight min/max values in straight table | Qlik Community

Re: Creating Gauge chart (Trafficlight chart)

migueldelval — Wed, 13 Jul 2016 08:40:55 GMT

Hi Ampel,

Try this example

Regards

Miguel del Valle

Re: Creating Gauge chart (Trafficlight chart)

thanhphongle — Wed, 13 Jul 2016 08:52:29 GMT

Hello Miguel del Valle,

thank you for answering my question. I just opened your attached file. If i choose the RentNr. 1005 and 1006. it returns me a black light although it should be red as the PV are over 0,90.

Could you check this out again?

Re: Creating Gauge chart (Trafficlight chart)

thanhphongle — Wed, 13 Jul 2016 08:59:48 GMT

oh I just figured out. I have to rais the max value . Thanks anyway for you help !