How does HRANK work? (Highest total sale marked as red)

[anitamelbye]

Dear all,

I have been trying to understand the use of HRANK
http://community.qlik.com/forums/t/21345.aspx but I just don't get it to work.

Please see my attached simplifyed file.
I would like to have the highest Total Sale marked as red, but it will not work..

I am thankful for any advise on this, and I do not have to use HRANK if there is another way to solve this, that works!

*Newbee*

[#2 · Accepted solution]

Hy,
this works:
if(aggr(rank(aggr( Price*Sold,Name),0,1),Name)=1,red())

Greetings,
Piet</body>

[anitamelbye]

Dear Piet!

Thank you so much for answering, but I am so sorry, it still doesn't work.

Do you have time to look at it once more? Please...? 🙂

Best regards
Anita

[#4]

Hi Anita,

Try this :

if

(RANK(total Price*Sold)=1, red())

regards,

[anitamelbye]

Piet and QVCON!

Thank you, both of you. Both of the Code's work!

My screen was so dark, I could not see the difference between red and black. When I changed the color to lightred, it surely helped a lot!

Thank's again for helping out.. 🙂

*newbee in red*