topic Re: TOP N Values in App Development

TOP N Values

ena1309 — Wed, 25 May 2022 08:12:29 GMT

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 — Wed, 25 May 2022 08:54:35 GMT

Please follow this link and hope this helps..

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 — Wed, 25 May 2022 09:00:52 GMT

@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: