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: 
Not applicable

Traffic Light Question

I have the following information:

Here is what my application shows:

ListBox one contains all the products we have. (Product1,Product2,Product3,etc)

ListBox two contains all the industries we serve. (Industry1, Industry2, Industry3, etc)

Here is what I would like to show.

AcctNumber          OrganizationName               ProductName          Traffic Light  

123                         Balls Store                              Product1

123                         Balls Store                              Product2

234                         Pales Store                             Product1               (green light)

345                         Young Store                            Product1

345                         Young Store                            Product2

456                         Hall Store                                Product1               (green light)

Is there a way to do this?  The reason I am need this information is they are my upsell opportunities.  Any suggestions would be helpful.

David

1 Solution

Accepted Solutions
maxgro
MVP
MVP

if the question is how to make traffic lights, here an example

this is the expression

if(Sum (Expression1)>3000,

'qmem://<bundled>/BuiltIn/led_g.png',

'qmem://<bundled>/BuiltIn/led_r.png'

)

1.png

View solution in original post

2 Replies
chematos
Specialist II
Specialist II

I don't understand what is your problem. Have you created the table? You would need a condition to set the color of the traffic lights.

What is your problem exactly?

maxgro
MVP
MVP

if the question is how to make traffic lights, here an example

this is the expression

if(Sum (Expression1)>3000,

'qmem://<bundled>/BuiltIn/led_g.png',

'qmem://<bundled>/BuiltIn/led_r.png'

)

1.png