topic Traffic Light Gauge Settings in QlikView

Traffic Light Gauge Settings

Thu, 29 Apr 2010 17:56:28 GMT

I'm trying to set different goals based on the location. So the green on the gauge would start at a different spot depending on the location. Below is an example of what I'm trying to do. The gauge is being shown within a column in a table chart with the location as the dimension. Using the formula below it is just showing green starting at .5 for all locations. Thanks in advance!

IF(LocationShortNM='ANW',0.814,IF(LocationShortNM='BUF',.9,.5))

Traffic Light Gauge Settings

Thu, 29 Apr 2010 20:15:21 GMT

Is LocationShortNM supposed to be the selected value in that field? Or do you have multiple guages for different values (and then use Set Analysis in the expressions)?

The problem you are having is that these setting are not reevaluated for each record.

If you want to base it off selections, use an expression like:

if(GetFieldSelections(LocationShortNM) = 'ANW', 0.814,
If(GetFieldSelections(LocationShortNM) = 'BUF', .9, .5))

Traffic Light Gauge Settings

Fri, 30 Apr 2010 19:41:35 GMT

No good....

I created a variable in the script that assigned a value based on the Location. When I pull that variable into the table chart expressions it shows the correct value corresponding to each row (Location). The variable works.

When I enter the variable name into the Guage Settings - Lower Bound value and apply it just fills all green (I tried switching to the circular gague so that I can see the value in the field is correct).

So, I'm still having an issue of having the lower bound in the gauge adjust based on the location.

Traffic Light Gauge Settings

fernandotoledo — Fri, 30 Apr 2010 19:58:16 GMT

Did you unchecked the Properties>Presentation> "Autowidth Segments" ?

Traffic Light Gauge Settings

Fri, 30 Apr 2010 20:44:12 GMT

I had un-checked Autowidth Segments.

Figured out a work-around. I'm changing the value of the field to the % difference from goal so that all the locations will be based on a common calculation. Then the segment bounds will all be the same.

Thanks for everyone's help!