Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Top n values


Hi,

I have a straight table. I wish to display top 25 records based on the expression values.

e.g. Dimenion is ID

Expression is Sum(Sales).

How do i display top 25 records based on the expression?

5 Replies

Re: Top n values

se dimension limit, the second tab of your chart

jyothish8807
Honored Contributor II

Re: Top n values

Hi Aama,

Try,

Use this as Dimension:

if(Aggr(Rank(Sum(Sales),ID)<=25,ID)

Expression:

Sum(Sales)

Regards

KC

Best Regards,
KC
MVP
MVP

Re: Top n values

for a str table and 25 you can also use max number in presentation tab

here a lot of useful different way

Show Top Performers

Not applicable

Re: Top n values

Hi,

In my straight table, i am having two dimensions ID and Group.

Expression is: sum({<DateYr={'2014'}>}Sales)

How do i display to 25?

Do i have to use dimension limits for both the dimensions?

Highlighted
Not applicable

Re: Top n values

Hi Asma,

You can use it on the first dimension ID, to see the Largest 25 Sales irrespective of Group.

If you want to see largest 25 in each top 25 ids you can use dimension limit on both ID and Group

Thanks,

Shruthi Reddy

Community Browser