4 Replies Latest reply: Jan 11, 2018 10:38 AM by Nick Lee RSS

    Pivot Table, rows colored depending on the data in the row?

    Nick Lee

      Hi all,

       

      I have a pivot table in Qlik Sense of months as columns, with data for each value in my rows. I want to grade each row with a color gradient dependent on the rank of values in the cells.

       

      For example for a row, if January has value 1, and December has value 12 (with steps of 1 increasing), I'd like to have a color gradient across these cells, with the largest being opposite to the smallest value in color.

       

      I've tried some solutions in the formula bar for the color of my data but no luck.

       

      Any help would be greatly appreciated.

       

      Cheers


      Nick

       

      chrome_2018-01-11_13-55-46.png