2 Replies Latest reply: Jul 9, 2015 11:54 AM by Marta Portugal RSS

    How to conditionally colour a pivot table in Qlik Sense?



      I am trying to format my pivot table in Qlik Sense the way I'd do it in Excel, by color-scaling a set of values based on the range of values.

      I have managed to do something like


      if([Quotability] <= 0.35, red(), if([Quotability] > 0.35 and [Quotability] <=0.75, yellow(), green()))


      but I would like a "smarter" formula, maybe based on quartiles instead of predetermined values.


      Does anyone know how to do this?