Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Highlighted
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?

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