Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
3 Replies
Not applicable

Re: Colour Expression in Sense

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

Re: Colour Expression in Sense

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

igdrazil
Contributor III

Re: Colour Expression in Sense

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