Traffic Lights in Tables

[#1]

Hello guys,

I have a problem with setting traffic lights in a table. I would like to set for example RED if the data is bigger than the 10% of a field, etc. So they depend on the data.. my problem is that it applies the % to all the data of the field. The table is like this:

For example, I want that in the line of 'Análisis' the traffic lights is set due the value of "Estimación Original", but only of 'Análisis', not of the total. But as you set the limits in the segments, I suppose it's global and equal to all the table. If I select a field it changes to the right color:

Does anybody know how can I have the right color at every line or have the limits depending of the field? Thanks!

Júlia

[MK_QSL]

Traffic light indicator in straight table

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#4]

yes, done

[#5]

Hey, I didn't get your problem, if it is something related to selection and color is changing then you can use  {<Etiquetas=>}  in segment expression.

[Gysbert_Wassenaar · Accepted solution]

I think you want to use separate boundaries for each value of Etiquetas. That's not possible with an inline gauge. Those boundaries are calculated at the chart level. What you can do instead is use the built-in images. You can use an expression like:

If( ExpressionValue >= 1, 'qmem://<bundled>/BuiltIn/led_r.png',

     If( ExpressionValue >= 2, 'qmem://<bundled>/BuiltIn/led_o.png',

          If( ExpressionValue >= 3, 'qmem://<bundled>/BuiltIn/led_g.png', 'qmem://<bundled>/BuiltIn/led_b.png'))))

You then need to set the Representation type of the expression to Image and probably also set the Image Formatting setting to Keep Aspect.

[#7]

No, the problem is that it only sets the right color when I select it (Because it calculates the same limits at all the table). I would like it to calculate the limit with the data of the line only, not global.

[#8]

ok.. I hoped that I could do it with Traffic Lights, but I see that I'll have to do it with Images. Thanks!

[#9]

It tells me that Nested aggregation is not allowed, do you know what I should do?

[Gysbert_Wassenaar]

Use the aggr function: min(aggr( sum(...), Dim1,...,DimX))