11 Replies Latest reply: Apr 5, 2018 7:09 AM by Harish Gali RSS

    Pivot Table - Background Colour by Expression

    Finbar Gillen

      Hi All,

       

      I am trying to create a conditionally formatted pivot table. I am trying to use the colormix2 function in the Background color expression box to create the conditional formatting, however it is only throwing one color out.

       

      ColorMix2((Count(DISTINCT {<status={'1'}>} UNIQUE_ID)/

      Count(DISTINCT UNIQUE_ID)) , rgb(180,212,218), rgb(28,95,158))

       

      Has anyone any ideas how I could modify this code in order to have 4 distinct colors based on the min to max values in the table?

       

      qlik.JPG

      Regards

      Finbar