Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Re: Color Mix per Dimension

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

Re: Color Mix per Dimension

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

Highlighted
Contributor III
Contributor III

Re: Color Mix per Dimension

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.

Highlighted
Creator
Creator

Re: Color Mix per Dimension

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

Highlighted
Contributor III
Contributor III

Re: Color Mix per Dimension

That is exactly what I'm looking for.

Thank you Bruno.