Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

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.

Regards,

Jagan.

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