Re: Coloring Text - Qlik Community

Report Inappropriate Content · ‎2016-06-03

Please how do I color my text like the code below.

if(Sum(Actual) >= Sum(Target) ,

Red(FILLED UP), Green(NOT FULL)
)

Chanty4u · ‎2016-06-03

try

if(Sum(Actual) >= Sum(Target) ,Red(),Green())

Colin-Albert · ‎2016-06-03

Changing font colours with an expression is not currently possible in Sense (v2.2.4)

You can change the background image to set a background colour of a text object but the image cannot be changed using an expression.

Anonymous · ‎2016-06-03

Hi...

I have changed the colour of my measure variance with the below expression:

if((Sum({<Version = {"Actual 2015"}>}SumOfBudget_Amount) -

Sum({<Version = {"Actual 2016"}>}SumOfBudget_Amount))/1000000 < 0,RGB(255,0,0))

Screen shot attached .. Please let me know if this what you are looking for :

Thanks

Report Inappropriate Content · ‎2016-06-03

No this is what I have already. Its the text am trying to color

Report Inappropriate Content · ‎2016-06-03

Here you are applying color to number not text. It doesn't work for text

Report Inappropriate Content · ‎2016-06-03

No, This doesn't answer my question

Colin-Albert · ‎2016-06-03

This is from the Sense Help

Visualizations that support color by expression

The following visualizations support color by expression:

Report Inappropriate Content · ‎2016-06-03

Its Text in KPI control am working on

Colin-Albert · ‎2016-06-03

You can use Conditional Colours with a KPI object

Here is the help on KPI objects