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 dimension in pivot table

Hello.

Does anyone know how to limit the display of one dimension in a pivot table to first 10 items ?

For instance, I want to display only the 10 most important countries in terms of measure in the pivot table below ?
Is this possible?

Thank you very much.


































 

Institute


 

 

Country


 

 

FRANCE


 

 

ETATS-UNIS


 

 

ALLEMAGNE


 

 

ROYAUME-UNI


 

 

ITALIE


 

 

ESPAGNE


 

 

CANADA


 

 

SUISSE


 

 

BELGIQUE


 

 

PAYS-BAS


 

 

CHINE


 

 

JAPON


 

 

SUÈDE


 

 

P150


 

 


 

 

40000


 

 

6000


 

 

4000


 

 

3500


 

 

3000


 

 

2500


 

 

2000


 

 

1950


 

 

1900


 

 

1850


 

 

1350


 

 

1200


 

 

1100


 
5 Replies
SunilChauhan
Champion
Champion

select the aoptions as in snapsnap.png

Sunil Chauhan
Anonymous
Not applicable
Author

But Pivot table there is no dimention limit tab...so how to display top 10 dimension in pivot table?

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

tresesco
MVP
MVP

You have to use rank() function possibly in combination with aggr(). Somehting like:

=Aggr( If( Rank(Sum(Sales))<11, Country), Country)  , in calculated dimension. Then check 'Supress When Value is Null' in the dimension tab.

VENKY_A
Contributor II
Contributor II

I want to restrict based on month name. I have dimension Month and I have to show only last 6months. How can we achieve this?