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

Colour Expression in Sense

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

3 Replies
Not applicable
Author

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

Conditional Color.PNG

Not applicable
Author

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

igdrazil
Creator III
Creator III

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