Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any way to be able to do this?
With Qlik Sense Pivot Tables - You can highlight the Cell Values based on your criteria.
This example shows highlighting the cells for all sales over $5000.
This type of color expression needs to be placed in the Background Color Expression area of the Measure details on the right side of sense.
To highlight the max value, you can use something as background color expression like
=If( Sum(Value)=Max(TOTAL Aggr( Sum(Value), Product, Customer)),Yellow())
Sum(Value) being the expression in the chart and Product, Customer the dimensions.
Hi,
Maybe try this below expression, select EDIT (little pencil icon at top right) then select Appearance then Colors then change the colors to By Expression.
IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW())
Where YELLOW() is whatever color you want.
Here is the full function for Top and Bottom
IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW()
,IF(Sum([Value]) = RANGEMIN(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),RED()))