Background color expression not working correctly

[andrewmo]

Hello

I have an expression that is supposed to color code values as green that are greater than 70% however it is color coding values green that are less than 70%. Below is a screen shot of the expression and the output. The total at the top is 63.9% which is less than 70%; why is it green?

[Oleg_Troyansky · Accepted solution]

Hi Andrew,

your color expression can only be valid at the detailed level, not at the total level. At the total level, the field [Day Utilization" may return multiple results, which turns the value to NULL and the whole expression is invalid. In this case, I'm guessing, the background color of the first row is adopted for the total.

I'd recommend to make your calculation valid at the total level and hopefully it resolve the issue.

I'd also recommend to add the default color value that should be used if both conditions are false. Currently, it returns NULL as the default. It might also cause the same issue.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Prague this April!