TOP N Values

[ena1309]

Hi guys, 

I have a table chart and i want it to show the top 10 values. (so it means first 10 rows)
how to do that?

thank you
ena

[Raja2022]

Please follow this link and hope this helps..

https://community.qlik.com/t5/QlikView-App-Dev/Top-N-values/td-p/505467

Also you can do it based on "Dimension limit" by following this link: https://k-shivanand.medium.com/top-n-chart-in-qlikview-68973b2e7a31

[Taoufiq_Zarra · Accepted solution]

@ena1309  or you can use dimension aggr like :

suppose you have this input table;:

and you want to show only first 10 dimension (Flag) based on row number :

use in dimension :

=aggr(if(rowno()<=10,Flag),Flag)

and suppress null value

in measure -> your measure

output: