Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Traffic Light Question

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

2 Replies
chematos
Valued Contributor II

Re: Traffic Light Question

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?

MVP
MVP

Re: Traffic Light Question

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

Community Browser