Finding the Max value in each row and column of a Pivot Table

[sarathi_pm]

Hi,

I have a scenario to highlight the maximum value in each row and each column of a pivot table.

If the cell value is maximum in each column, it has to be highlighted in yellow. if the cell value is maximum in a row, it has to be highlighted in blue.

if the cell is the maximum in both the row as well as in column it has to be highlighted in Orange.

I tried with Aggr and Rank functions. but couldn't make it work.

Any help is much appreciated.

Thanks

Sarathi

[tresesco]

PFA

[sujeetsingh]

Follow this

Find the maximum value in pivot table | Qlik Community

[settu_periasamy]

this will also work..

Background Color

if(sum(Count)=Max(TOTAL Count),RGB(250,192,144),
if(sum(Count)=Max(TOTAL <Country> Count),Blue(),
if(sum(Count)=Max(TOTAL <User> Count),Yellow())))

Text Color

if(sum(Count)=Max(TOTAL Count),Black(),
if(sum(Count)=Max(TOTAL <Country> Count),White()))

[tresesco]

Yes the expression could be simplified, try:

if(sum(Count)=Max(TOTAL Count),RGB(255,128,64),

     if(sum(Count)=Max(TOTAL <Country> Count),RGB(117,153,213),

          if(sum(Count)=Max(TOTAL <User> Count),Yellow())))