Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Sir/Madam
I have used Rank several times without problem but not sure why Table B cannot be ranked properly, need help asap.
Thank you, Tracy
Hi @tracycrown
Try like this
Aggr(rank(avg(Score)), Number)
Hi @tracycrown
Try like this
Aggr(rank(avg(Score)), Number)
Dear Mr MayilVahanan_R
Wow, you are so clever and helpful
Thank you very much, Tracy
Dear Mr MayilVahanan_R
Can you advise how to sort the rank column ?
Thank you, Tracy
@tracycrown Here is a Design Blog post on Rank function that may be of some help on your follow-up question, but not sure:
https://community.qlik.com/t5/Qlik-Design-Blog/Rank-Function/ba-p/1466430
If you want to search further in that area, use the following link:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett
Dear Brett_Bleess
I am very sorry for not responding to your advice as I was too busy in my work, thank you very much for your help.
Best Regards, Tracy