Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
venelin_rs
Contributor III
Contributor III

Color Mix per Dimension

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.

1 Solution

Accepted Solutions
bcavestro
Creator
Creator

HI

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

Here's the result ...

View solution in original post

4 Replies
bcavestro
Creator
Creator

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
Contributor III
Contributor III
Author

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.

bcavestro
Creator
Creator

HI

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

Here's the result ...
venelin_rs
Contributor III
Contributor III
Author

That is exactly what I'm looking for.

Thank you Bruno.