Help with a color expression

[mrmatt]

Hello

I'm trying to color a map based on an expression however using this formula, Qlik Sense is only choosing the first statement (i.e. only painting Red values). Am I missing something?

=if(([Numerator]/Denominator) <= .6, Red(),

if(([Numerator]/Denominator) <= .8, Yellow(),

if(([Numerator]/Denominator) <= 1.2, Green(),

if(([Numerator]/Denominator) >= 1.2, Black()

))))

THanks,

[Gui_Approbato · Accepted solution]

Hello,

I think you need to aggregate these measures.. So instead of ([Numerator]/Denominator) , try avg or sum, like avg([Numerator])/avg(Denominator) .

Try that and tell us if it worked.

Cheers