Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Contributor III

Re: Limit to Top 10 in Pivot Table

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

Re: Limit to Top 10 in Pivot Table

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
Contributor III

Re: Limit to Top 10 in Pivot Table

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

Community Browser