topic Re: Same content but cannot Rank properly in QlikView

Same content but cannot Rank properly

tracycrown — Fri, 15 Nov 2024 23:43:50 GMT

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 — Wed, 28 Oct 2020 07:38:29 GMT

Try like this

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

tracycrown — Wed, 28 Oct 2020 09:33:20 GMT

Dear Mr MayilVahanan_R

Wow, you are so clever and helpful

Thank you very much, Tracy

tracycrown — Wed, 28 Oct 2020 14:13:47 GMT

Dear Mr MayilVahanan_R

Can you advise how to sort the rank column ?

Thank you, Tracy

Brett_Bleess — Thu, 05 Nov 2020 20:34:49 GMT

@tracycrown Here is a Design Blog post on Rank function that may be of some help on your follow-up question, but not sure:

If you want to search further in that area, use the following link:

Regards,
Brett

tracycrown — Wed, 11 Nov 2020 04:01:39 GMT

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