topic Re: Limit dimension in pivot table in QlikView

Limit dimension in pivot table

Mon, 28 Jan 2013 13:29:09 GMT

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

SunilChauhan — Mon, 28 Jan 2013 13:40:01 GMT

select the aoptions as in snap

Anonymous — Tue, 28 Jan 2014 05:42:20 GMT

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

phaneendra_kunc — Tue, 28 Jan 2014 05:45:18 GMT

TRy a RANK function

tresB — Tue, 28 Jan 2014 05:47:21 GMT

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 — Sun, 05 Dec 2021 08:50:02 GMT

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?