Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Coloring max and min values in PivotTable Qlik Sense


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!


Tags (1)