Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting Text Colour based on the value of a variable

Hi,

I would like to format a text as red, amber, or green depending on a parameter that is not in the text box.

I would like to display a production total for the month such as 12/50.

Then I would like to create a variable that takes into account which day of the month we are in, such as:(Completed/Target)/(day(today())/MonthLength).

Then I would like the 12/50 to be green if the variable >0.9, Amber >0.75, red <0.75.

Is there a way to do this?

Many thanks in advance for your help!

Will

0 Replies