0 Replies Latest reply: Nov 6, 2015 4:01 AM by Homer Cruzado RSS

    Gradient Color for Tree Map (Qlik Sense)

    Homer Cruzado

      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

      .