Discussion Board for collaboration related to QlikView App Development.
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.
select the aoptions as in snap
But Pivot table there is no dimention limit tab...so how to display top 10 dimension in pivot table?
TRy a RANK function
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.
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?