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é