Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Display Top n by Dimension in Pivot table


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:
‎02-27-2013 08:38 AM
Updated by: