Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Dafna2020
Contributor
Contributor

Colormix doesn't color a total

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..

 

Labels (1)
1 Solution

Accepted Solutions
a_mullick
Creator III
Creator III

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

Azam

View solution in original post

4 Replies
a_mullick
Creator III
Creator III

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
Creator III
Creator III

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

Azam

Dafna2020
Contributor
Contributor
Author

Thanks,

I was using the Colormix wizard...

AndrewHughes
Partner - Contributor III
Partner - Contributor III

Please mark as solved.