Customization

[#1]

hi,

how could i get the top 10 names of my report based on the other field.i tried doing it by using dimension limits.but it is not coming.please tell me

Thanks and Regards

Darshika

[amit_saini]

Hi Darshika,

Please use Rank() function. Below sharing 3 different ways of calculating based on conditions:

Syntax:

=rank(sum(Investment),1,1)

AND

=aggr(if(Rank(sum(Investment))<=3,Investment),Investment) (For calculating Top 3)

AND

=if(rank(sum(Investment),1,1)=1,'# 1') (For Calculating #1)

Thanks,
AS

[maxgro]

there are different solutions, here a very good doc about top

Show Top Performers

if you want somne help on your specific qlik doc, better to post it