Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit to Top 10 in Pivot Table

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?

Top.png

3 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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

sales.PNG.png

so I added this expression in dimensions

Capture.PNG.png

and as a result I have

Capture.PNG.png

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

bgerchikov
Partner - Creator III
Partner - Creator III

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