topic dynamic gauge settings in QlikView

dynamic gauge settings

Thu, 12 Nov 2009 20:48:00 GMT

Hi,

I have a pivot table and with a Process name and measures like Actual, Target and Trend. It looks like this:

ProcName Actual Target Trend

Test1 85,0 91,0 93,0

Test2 1,7 2,0 1,9

Test3 110,0 100,0 109,0

In my expression box I created a expression with as representation a traffic light gauge. In this gauge I want to see 3 colours:

-1. GREEN= Actual<Target

-2. YELLOW=Actual=Target

-3. Red= Actual>Target

Any idea how to do this?

Kind regards

Maarten

Thu, 12 Nov 2009 22:47:10 GMT

Hello,

Maybe this will be helpful attached is the application

Talha

Thu, 12 Nov 2009 22:49:09 GMT

attaches the file again

Thu, 12 Nov 2009 23:00:08 GMT

Try again