topic Max(Rank()) issue in pivot table in QlikView

Max(Rank()) issue in pivot table

Mon, 31 Dec 2012 07:39:16 GMT

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.

Re: Max(Rank()) issue in pivot table

SunilChauhan — Mon, 31 Dec 2012 09:21:59 GMT

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

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

hope this helps

Re: Max(Rank()) issue in pivot table

Mon, 31 Dec 2012 11:03:48 GMT

Hi,

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