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

      Hi,

       

      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!

       

      André