Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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*
Hy,
this works:
if(aggr(rank(aggr( Price*Sold,Name),0,1),Name)=1,red())
Greetings,
Piet</body>
Hy,
this works:
if(aggr(rank(aggr( Price*Sold,Name),0,1),Name)=1,red())
Greetings,
Piet</body>
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
Hi Anita,
Try this :
if
(RANK(total Price*Sold)=1, red())
regards,
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*