topic Re: Customization in QlikView

Customization

Wed, 04 Jun 2014 09:06:34 GMT

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 — Wed, 04 Jun 2014 09:12:26 GMT

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 — Wed, 04 Jun 2014 09:29:25 GMT

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

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