Qlik Community

QlikView Documents

Documents for QlikView related information.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER

Display Top n by Dimension in Pivot table

MVP & Luminary
MVP & Luminary

Display Top n by Dimension in Pivot table

Attached document helps in displaying the Top n values by dimension.  In calculated dimension I am limiting to display Top 3 values for each value in first dimension. If you want to increase the Top n values to be displayed just replace N in the below expression.

=aggr(if(rank(FAILURE) < (N + 1), TEST),LOCATION,TEST)

Hope this helps others.



Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2013-02-27 08:38 AM
Updated by: