topic Top n values in QlikView

Top n values

Fri, 10 Oct 2014 07:43:50 GMT

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?

alexandros17 — Fri, 10 Oct 2014 07:48:13 GMT

se dimension limit, the second tab of your chart

jyothish8807 — Fri, 10 Oct 2014 07:51:37 GMT

Hi Aama,

Try,

Use this as Dimension:

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

Expression:

Sum(Sales)

Regards

maxgro — Fri, 10 Oct 2014 08:04:57 GMT

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

here a lot of useful different way

Fri, 10 Oct 2014 08:28:44 GMT

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?

Fri, 10 Oct 2014 08:34:28 GMT

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