Discussion Board for collaboration on QlikView Layout & Visualizations.
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...
View solution in original post
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
I was using the Colormix wizard...
Please mark as solved.