topic Re: Help with traffic light gauge in QlikView

Help with traffic light gauge

Fri, 20 Jul 2012 12:07:06 GMT

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.

Re: Help with traffic light gauge

cesaraccardi — Fri, 20 Jul 2012 13:44:44 GMT

Hi there,

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

Re: Help with traffic light gauge

Fri, 20 Jul 2012 14:12:05 GMT

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

Re: Help with traffic light gauge

Mon, 23 Jul 2012 10:36:45 GMT

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

Re: Help with traffic light gauge

Mon, 23 Jul 2012 10:38:00 GMT

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

Re: Help with traffic light gauge

cesaraccardi — Mon, 23 Jul 2012 12:33:06 GMT

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