0 Replies Latest reply: Feb 20, 2017 2:33 PM by Robotica Robotica RSS

    Coloring max and min values in PivotTable Qlik Sense

    Robotica Robotica



      I would like your help.


      I'm using Qlik Sense and it has a PivotTable.


      I would like to color the background of a column by putting the maximum values in red and the minimum in blue. But I need this done for each Product.


      As 'lines' I have: Product and State

      As 'mesures' I have: Value


      Product A        Value

      FL                    100

      TX                    200

      CA                   300

      Product B

      FL                    150

      TX                   130

      CA                   120


      Could anyone tell me what formula should I put in Background Color Expression for Value measure?


      Thank you!