Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Customization

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

2 Replies
Highlighted
Master III
Master III

Re: Customization

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

Highlighted
MVP
MVP

Re: Customization

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