Coloring Text

[#1]

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

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

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

[Chanty4u]

try

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

[Colin-Albert]

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.

Re: How to use custom colours?

[Anonymous]

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

[#5]

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

[#6]

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

[#7]

No, This doesn't answer my question

[Colin-Albert]

This is from the Sense Help

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Colors/color-by-expression.htm

Visualizations that support color by expression

The following visualizations support color by expression:

• Bar chart
• Combo chart
• Line chart
• Map
• Pie chart
• Scatter plot
• Table
• Treemap

[#9]

Its Text in KPI control am working on

[Colin-Albert]

You can use Conditional Colours with a KPI object

Here is the help on KPI objects

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Visualizations/KPI/KPI-properties-panel...