Colormix doesn't color a total

[Dafna2020]

Hi,

I'm using Colormix in a straight table.

When the expression is a Sum, the total isn't colored.

When the expression is a percentage, the total is colored.

Any idea why and what to do?

Thanks in advance..

[a_mullick]

The ColorMix() functions only work with values between -1 and 1. Hence percentages work, but values greater than 1 or less than -1 will not yield the results you expect.

There are a couple of ways to deal with this, but the easiest is probably to use the ColorMix wizard:

ColorMix Wizard Help Page 

Best wishes,

Azam

[a_mullick · Accepted solution]

Attached is a QlikView app that shows a couple of different methods...

Azam

[Dafna2020]

Thanks,

I was using the Colormix wizard...

[AndrewHughes]

Please mark as solved.