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

    How to conditionally colour a pivot table in Qlik Sense?

      Hi,

       

      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?

       

      Thanks,

      M.