Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
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

MVP
MVP

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.

Regards,

Jagan.

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