Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Marchine
Contributor
Contributor

Changing text and font color simultaneously

Hello

I am currently trying to create an app.

I have a variable defined from 1-3, meaning "go", "wait", "stop"
- When choosing 1, i want it to display "go" displayed in a green font.
- When choosing 2, i want it to display "wait" displayed in yellow font. 
- When choosing 3, i want it to display "stop" displayed in red font. 

I have found two individual solutions. 
- If(Sum([Variable]) = 1, 'Go', If(Sum([Variable]) = 2, 'Wait', If(Sum([Variable]) = 3, 'Stop', '')))
- If(Sum([Variable]) = 1,RGB(78,181,35),If(Sum([Variable]) = 2,RGB(255,182,0), If(Sum([Variable]) = 3,RGB(224,48,30),RGB(255,255,255))))

How can i combine those/ do it easier?

Labels (2)
0 Replies