Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-10-13 12:24 AM

How to do a TOP X in a pivot table?

I need to load the top 5 records from a dimension in a pivot table, but I seem to be stuck. The top() function doesn't seem to be working as I expect. Thanks.

Labels (1)
Labels
446 Views
0 Likes
1 Reply
prasad
Contributor III
Contributor III
‎2009-10-13 04:52 AM

Hi,

I beleive this can be easily achieved from Straight Table, where the dimenstion can easily be sorted out for Top values. Thanks!

Regards,

Prasad

274 Views
0 Likes