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, ...
Get QlikView for Developers Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
