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

Help with traffic light gauge

On a Qlikview file I have a detailed report which consists of a simple table that has a traffic light on each of the rows. Ex:

Item      |  Place     |   Date           |    Traffic light

Chair       Store        Monday           Red

table        Market     Monday           Green

Glasses   Store        Tuesday          Green

...               ...               ...

...               ...               ...

Then I have another table without the items, which also has a traffic light. If at least one item from the place has a red traffic light on the other table, then on this table the traffic light is shown red. Following the previous example:

Place        | Traffic light

Store           Red   (The chair on the previous table was red)

Market         Green (there is only a table from the market and it's green)

I'd like to know if there's any way that when I click on the red traffic light on the second table, all of the items from that place with a red light were selected on the first table.

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Hi biel,

I think you don't have a chance to click onto the traffic light directly. So try to use a button with a "Select in Field"-action. Your seach-field should be "Item" and your search string should contain the chart's expression (in single quotes!) which "turns the red light on".

Example for the searchstring to select all having sum(Val1) more than 4:

='=Sum(Val1) > 4'

So copy your expression from the chart into the serach-string like above and try it.

HtH

Roland

View solution in original post

5 Replies
cesaraccardi
Specialist
Specialist

Hi there,

Please take a look... Is that what you want?

Not applicable
Author

Hi biel,

I think you don't have a chance to click onto the traffic light directly. So try to use a button with a "Select in Field"-action. Your seach-field should be "Item" and your search string should contain the chart's expression (in single quotes!) which "turns the red light on".

Example for the searchstring to select all having sum(Val1) more than 4:

='=Sum(Val1) > 4'

So copy your expression from the chart into the serach-string like above and try it.

HtH

Roland

Not applicable
Author

Hi Accardi, thanks for answering, but I was unable to view any information on that file, I could only see empty tables.

Not applicable
Author

Thanks a lot Ronald, I didn't know you could do that and it worked perfectly.

cesaraccardi
Specialist
Specialist

Hi... i think you are using Personal Edition... ok, no problem.