Top 25 ranking results to more than 25 records

[xarapre7]

I have the below expression which should show the top 25 customers based on CallsAnswered.  However, it's not showing the expected results.

=if(aggr(rank(sum(CallsAnswered)),[Customer])<=25, [Customer])

If there are 3 customers with all the same number of total calls, they should all receive the same rank.

Please see attached file for example. 

Thank you in advance for your help. 

[sunny_talwar]

May be try a different mode within Rank function

Rank ‒ QlikView‌

May be you need one of the two

Or for more robust, but complicated approach, try this

Continuous Ranking (no missing Rank)

[Anonymous]

In my case, I had the similar problem, I need to have 10 bottom rows and Rank function retriew more than 10 rows. I used the next set analisys in action propiety in an button object, with the mode 4 to the Rank function:

='('&Concat(If(Aggr(Rank(-Max(Nota),4) <= 10,Dimension_A  ),Dimension_A),'|',Nota)&')'

Many Thanks for you suggestion

[sunny_talwar]

May be this

Continuous Ranking (no missing Rank)