Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi there,
Please take a look... Is that what you want?
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
Hi Accardi, thanks for answering, but I was unable to view any information on that file, I could only see empty tables.
Thanks a lot Ronald, I didn't know you could do that and it worked perfectly.
Hi... i think you are using Personal Edition... ok, no problem.