topic Re: Traffic Lights like Excel in QlikView

Traffic Lights like Excel

Anonymous — Fri, 12 Aug 2016 13:20:56 GMT

Does QlikView have something similar to Excel with their traffic lights which are created using conditional formatting?

Below is an example of what I am talking about. There is a little dot of color next to each value indicating whether the change is positive or negative.

Thanks

Re: Traffic Lights like Excel

Kushal_Chawda — Fri, 12 Aug 2016 13:27:10 GMT

example , 10% -20% Red, 30%-40% Green

=if( YourExpression >= 0.1 and YourExpression<=0.2,'qmem://<bundled>/BuiltIn/led_r.png',

if( YourExpression >= 0.3 and YourExpression<=0.4,'qmem://<bundled>/BuiltIn/led_g.png'))

Note: Display Option->Representation Should be Image, Image Formatting->Fill Aspect

Re: Traffic Lights like Excel

narendiran — Fri, 12 Aug 2016 13:30:24 GMT

Use LED Gauge representation in straight table. See below link for more details

Re: Traffic Light Indicators in straight table

Re: Traffic Lights like Excel

Anonymous — Fri, 12 Aug 2016 13:43:26 GMT

Thank you

Re: Traffic Lights like Excel

Anonymous — Fri, 12 Aug 2016 15:50:55 GMT

Do you know if this will work with dimensionality? If I have two values within one cell, can I display two images? Thanks.