Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Colormix doesn't color a total

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

Azam

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Re: Colormix doesn't color a total

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

Highlighted
Creator III
Creator III

Re: Colormix doesn't color a total

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

Azam

View solution in original post

Highlighted
Contributor
Contributor

Re: Colormix doesn't color a total

Thanks,

I was using the Colormix wizard...

Highlighted
Partner
Partner

Re: Colormix doesn't color a total

Please mark as solved.