Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
aaah this is more than useful, thank you very much 😃