Background Color Expression

[Anonymous]

I am attempting to highlight a field in a Pivot Table object both Charts and Custom Objects > Qlik Visualization Bundle when the amount exceeds 100%. Seems basic enough under the metric there is the Background Color Expression.

I entered the condition as so: IF(sum(Margin)/sum(MarginGoal)>1,'Mint','White')

However, nothing happens.

[MatheusC · Accepted solution]

Hi, @Anonymous 

The expression returns the correct percentage?

Are you using this 'Mint' return for color or is it just an example because this is not a valid color in the expression?

Color example, also in RGB, Hex color codes....


IF(sum(Margin)/sum(MarginGoal)>1,'#3EB489',White())


-Regards,  Matheus

[Kushal_Chawda]

@Anonymous  How many dimension do you have in pivot table?

[Anonymous]

Thank you, the issue was with setting the colors. I am transitioning QlikView 12 to Qlik Sense so thank you. Also the Qlik Help section is a little confusing. Looks like the issue may come down to what key color words they choose to set. https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expressi...