Colour Expression in Sense

[#1]

Hi

I have a text box with a measure Sum(TargetSales) I need it to change colour to Red and Green Depending on Condition.

So I am doing: If(Sum(TargetSales)<=sum(Sales), LightRed(Sum(Sales)),LightGreen(Sum(Sales)))

and it is not working.

Can someone help on this in Qlik Sense?

Thanks

[#2]

Have you tried putting the measure in the KPI chart object? Once you do that then you have the option of conditional coloring:

[#3]

Yeah it works in the KPI in the way you suggesting but i want to add this on a guage's footnote.

[igdrazil]

Hi Sarb,

If you remove the Title of the KPI-Object and decrease the size of it you could put it below the Gauge, so it would fit below the Gauge-Object.

As far as i know there is no way to color expressions at the moment (only Dimensions), but please correct me if i'm wrong.

Regards

Chris