Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi
Use LED Gauge representation in straight table. See below link for more details
Thank you
Do you know if this will work with dimensionality? If I have two values within one cell, can I display two images? Thanks.