Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Traffic Lights like Excel

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

1 Solution

Accepted Solutions
Kushal_Chawda

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

View solution in original post

4 Replies
Kushal_Chawda

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

narendiran
Partner - Creator
Partner - Creator

Hi

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

Re: Traffic Light Indicators in straight table

Anonymous
Not applicable
Author

Thank you

Anonymous
Not applicable
Author

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