Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Rank/ Aggr for Pivot table to get top 5

I want Top 5 fruits for 2016 and 2017 to be listed in the uploaded qvw.  If Top 5 of both year is not possible then I want top 5 fruits by 2017

I tried using dimensions limit by making it straight table. But then when i try to move the Fiscal year to the top column by moving blue arrow I cant. So I used pivot table, but in pivot table the dimension limits go away.

I think I need to use aggr function with rank function, but not sure how.

Can someone help me here?

Thanks once again

14 Replies
Highlighted

Could be a version related issue. What version of  QV you are using?

Highlighted
Creator
Creator

11.00.11282.0 SR1 64-bit Edition

Highlighted

Wow, you are still using SR1? Can you update to a more recent version of QV may be?

Highlighted
Creator
Creator

OMG..u are right...i just tested this one someone else's laptop who has later version and looked good there....how do you upgrade? or rather will check with IT team at my company

Thanks a lot

Highlighted