Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max(Rank()) issue in pivot table

Hi,

I have a pivot table with it's dimensions as hierarchy of employees and in the expression part i want to give a rank function.

I want to give a different color to Max(Rank())) , I.E 1,2,3,4,5 are the ranks that the cell with rank as 5 should have a different color from the rest.

Thanks for any kind of help

Utsav.

2 Replies
SunilChauhan
Champion
Champion

if(Max(Rank())=5,RED(),Green())

write color function for color needed in place of red and green

hope this helps

Sunil Chauhan
Not applicable
Author

Hi,

I dont know the eaxct max value with which i can compare...is there a way i can extract Max(Rank()) dynamically??