topic Colormix doesn't color a total in QlikView

Colormix doesn't color a total

Dafna2020 — Sat, 16 Nov 2024 01:33:19 GMT

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

Re: Colormix doesn't color a total

a_mullick — Thu, 09 Jan 2020 12:21:46 GMT

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

Re: Colormix doesn't color a total

a_mullick — Thu, 09 Jan 2020 14:22:52 GMT

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

Azam

Re: Colormix doesn't color a total

Dafna2020 — Thu, 09 Jan 2020 14:53:13 GMT

Thanks,

I was using the Colormix wizard...

Re: Colormix doesn't color a total

AndrewHughes — Fri, 17 Jan 2020 15:14:41 GMT

Please mark as solved.