topic Re: Rank top N on a chart in QlikView

Rank top N on a chart

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Rank top N on a chart

Brett_Bleess — Wed, 01 Apr 2020 14:02:21 GMT

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

Re: Rank top N on a chart

nkosinde13 — Mon, 20 Apr 2020 16:16:39 GMT

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