Rank top N on a chart

[nkosinde13]

Good day

Please advise how do I rank top clients, from top sales to bottom? I don't any specific number like Top 10, I want to rank all clients on the chart.Below is the Calculated dimension, so I want to replace the part where it displays only top 3, with all clients.

=Aggr(If(Rank(IF(
Num((Sum({<[Actuals Type] = {'TotalActual'},[Fin Year] = {"<$(vMaxFinYear)>=$(vMinFinYear)"}>} [Total Price])
- Sum({<[Actuals Type] = {'TotalActual'}, Section = {'OPIs'},[Fin Year] = {"<$(vMaxFinYear)>=$(vMinFinYear)"}>} ecamount)) / $(ThouMenu),'# ##0')
= 0,
Num((Sum({<[Actuals Type] = {'TotalActual'},[Fin Year] = {$(vMaxFinYear)},Closed = {1}>} [Total Price])
) / $(ThouMenu),'# ##0')
)) <=3, ClientName), ClientName)

Thanks and regards

Matlotlo

[Brett_Bleess · Accepted solution]

I believe the following two Design Blog posts may get you what you need on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Regards,
Brett

[nkosinde13]

aaah this is more than useful, thank you very much 😃