Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic gauge settings

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

3 Replies
Not applicable
Author

Hello,

Maybe this will be helpful attached is the application

Talha

Not applicable
Author

attaches the file again

Not applicable
Author

Try again