topic Re: Traffic Lights in Tables in QlikView

Traffic Lights in Tables

Fri, 17 Jul 2015 10:34:31 GMT

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

Re: Traffic Lights in Tables

MK_QSL — Fri, 17 Jul 2015 10:37:05 GMT

Traffic light indicator in straight table

Re: Traffic Lights in Tables

Gysbert_Wassenaar — Fri, 17 Jul 2015 10:39:19 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 10:42:33 GMT

yes, done

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 11:02:42 GMT

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.

Re: Traffic Lights in Tables

Gysbert_Wassenaar — Fri, 17 Jul 2015 11:30:16 GMT

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.

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 11:30:34 GMT

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.

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 11:32:14 GMT

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

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 11:38:27 GMT

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

Re: Traffic Lights in Tables

Gysbert_Wassenaar — Fri, 17 Jul 2015 11:45:30 GMT

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

Re: Traffic Lights in Tables

Fri, 17 Jul 2015 12:00:00 GMT

thanks!