Display unlimited identical ranked rows

[dana]

Hi,

I'm using a calculated dimension with the Rank function on the Deviation metric to limit  top 10 values in a straight table.

What I want to see are the top 10 values for different dates. But the Rank function limits the number of table rows. 

How do I remove the limit from the number of rows so I can see the top 10 deviations without the rows limitation?

Thanks in Advance!

[Brett_Bleess]

Have a look at the following Design Blog posts, may be helpful:

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

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/ba-p/14702...

Hopefully those may help.

Regards,
Brett

[dana]

Thank you for this link.

I resolved the issue by using AGGR with the Rank function:

=if(aggr(rank(Avg({<DateTime = {">=$(vYearStart) <=$(vMaxDateTime)"},Month=,Year=>}Deviation),4,1),DateTime)<=30,Timestamp(DateTime),Null())