Help with Table Chart and Gauge

[#1]

Hi there

As you can see from the attached QLIKVIEW file I have a small sample of data that consists of:

Lower-  a minimum value

Upper - the maximum value

Actual - the real value

I am using a table chart and want to add an addtional column that has a single trafiic light object for each row that reflects the value of the actual value within the range between lower and upper.

I have looked in the community posts and cant see anything obviuos and tried many things but to nor real avail.

Can somebody please look at my example and tell me what I need to do to get right.

Any help is much appreciated.

Thanks

Keith

[agomes1971]

Hi,

please see this

Creating a Good Looking Gauge Chart in Qlikview

HTH

André Gomes

[#3]

Hi Andre

Thank for for your reply.

It was useful to review but I am looking to use a traffic light gauge in a chart table for each row of data and not a seperate gauge which your example suggests.

Keith

[tracysmart]

you could make use of the images available which might be easier to work with than the gauges.

see attached