Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Attached is a QlikView app that shows a couple of different methods...
Azam
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:
Best wishes,
Azam
Attached is a QlikView app that shows a couple of different methods...
Azam
Thanks,
I was using the Colormix wizard...
Please mark as solved.