Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Coloring max and min values in PivotTable Qlik Sense

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é

0 Replies