Showing only the top 3 values in a pivot table

In version 11, QlikView introduced the feature Dimension Limits for most of the charts. This feature allows you to limit the number of values displayed based on a certain criteria; most usually, the value is in the top X (whatever X you want). It also allows you to include an Others dimension value for everything else outside the top X.

This feature is not available for gauge charts (which don't usually have a dimension anyway) and pivot tables.

In this recipe, we are going to implement the feature using AGGR in a pivot table.

Getting ready

Load the following script:

LOAD * INLINE [
  Year, Country, Sales
  2010, USA, 6013
  2011, USA, 5295
  2012, USA, 5551
  2013, USA, 6932
  2010, UK, 4512
  2011, UK, 3976
  2012, UK, 4691
  2013, UK, 5276
  2010, Japan, 2765
  2011, Japan, 2567
  2012, Japan, 3111
  2013, Japan, 3234
  2010, Germany, 4374
  2011, Germany, 5673
  2012, Germany, 4322
  2013, Germany, 7654
  2010, France, 4965
  2011, France, 5097...