Negative value in Rank

[qlikviewwizard]

Hi All,

Could anyone explain what does this formula do?

=If(Aggr(Rank(-Sum(Sales)) <= 20,Salesman),Salesman)

Thanks in advance.

[danieloberbilli]

I think it shows the top 20 Salesmen (e.g. as Dimension)   based on their sum of sales but also based on an inverse ranking of sales (so last rank becomes first rank)

[tresesco · Accepted solution]

Bottom 20. I.e. 20 salesmen who performed worst (minimum sales).