topic Re: Limit to Top 10 in Pivot Table in QlikView

Limit to Top 10 in Pivot Table

Thu, 16 Aug 2012 18:40:58 GMT

I have a Pivot table to counts to total number of referred physicians to Requesting physicians. How would I limit the view in this table to the Top 10 in count volume?

My dimensions are:

Requesting Phsycian

Referring Physician

My Expression is:

count(WP_CaseTable.Number)

How would I limit to top 10 by total count?

Re: Limit to Top 10 in Pivot Table

bgerchikov — Thu, 16 Aug 2012 19:31:12 GMT

Hi Robert,

You might use the rank function:

=sum(aggr(if(rank(count(WP_CaseTable.Number))<=10,count(WP_CaseTable.Number)), [Requesting Phsycian],[Referring Physician]))

Hope it will help

Re: Limit to Top 10 in Pivot Table

Fri, 30 May 2014 06:57:59 GMT

Good morning! friend

I am facing the same problem and I need your help

I try to display the first 10 sales per country in a Pivot table

so I added this expression in dimensions

and as a result I have

as you can see for 2010 it gives a result USA-> France-> germany and the logical order is USA-> France-> UK

why?

Thank you for your answers

Re: Limit to Top 10 in Pivot Table

bgerchikov — Mon, 02 Jun 2014 21:58:28 GMT

Hi Hanane,

Your table is sorted by value.

Try use sort by Country in your Sort tab: in Expression box put Country as a value.

Hope it will help