Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gradient Color for Tree Map (Qlik Sense)

Hi All,

I'm trying to assign a gradient color for my tree map by using the COLORMIX1() function. Below is a sample tree map, what I wanted to achieve is for each SEGMENT (i.e., convenience stores, restaurant and cafes, supermarkets, etc.), I should be able to assign a RGB() color, and each of the SALES REP per SEGMENT should be a gradient color of that assigned RGB.

Below is the syntax I'm trying to build...

If ( [Segment]='Convenience Stores',

     (colormix1((sum({<[Segment]='Convenience Store',[SalesRep]>} Revenue)) / Max(sum({<[Segment]='Convenience Store',[SalesRep]>} Revenue)),White(),RGB(250,2,3))),

     Red())

So the color would be a gradient of Red based on the sum of the maximum revenue of that sales rep in that segment.

Thanks in advance!

c1.PNG

.

0 Replies