Same content but cannot Rank properly

[tracycrown]

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

[MayilVahanan · Accepted solution]

Hi @tracycrown 

Try like this

Aggr(rank(avg(Score)), Number)

[tracycrown]

Dear Mr MayilVahanan_R

Wow, you are so clever and helpful

Thank you very much, Tracy 

[tracycrown]

Dear Mr MayilVahanan_R

Can you advise how to sort the rank column ?

Thank you, Tracy

[Brett_Bleess]

@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

[tracycrown]

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