topic Re: Color Mix per Dimension in QlikView

Color Mix per Dimension

venelin_rs — Wed, 25 Nov 2020 16:16:04 GMT

I want to use color mix function in pivot table and I want to be on the dimension level (in this case product).

For example, I want to know which is the max and which is the min for each product in the last 10 days.

Please see the attachment.

bc-thebruuu — Thu, 07 Jun 2018 09:08:23 GMT

Please take a look at the attachment

The backgrouod color of the expression contains the logic for background

and the font color too

In this way, you get what you shown on the Excel File

BUT this isn't colormix as colormix will set colors depending on how far/near you are far the min/max ...

venelin_rs — Thu, 07 Jun 2018 09:26:47 GMT

Thank you Bruno.

It's a good solution, but I have to upgrade that to be some kind of color mix.

Min result to be in red color and the max to be in green color as your example. So it's good first step

Now I have to put color to all values between min and max.

bc-thebruuu — Thu, 07 Jun 2018 09:35:35 GMT

You just need to use the min and max functions I wrote in the colormix wizard

Here's the result ...

venelin_rs — Thu, 07 Jun 2018 09:45:46 GMT

That is exactly what I'm looking for.

Thank you Bruno.