Qlik Community

QlikView Documents

QlikView documentation and resources.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Top 5 analysis using Rank fuction

Showing results for 
Search instead for 
Did you mean: 

Top 5 analysis using Rank fuction

We could use Rank function to find top 5 Record.

suppose we have Product wise sales below and we want to analysis of top 5 product Sales.then using Bar chart we can easily limit the dimension and achieve. but if we want in Pivot or straight table. it is not easy to find even using limit dimension.

Using rank function we could achive it easily

Raw Data:


rank of Sales


and top 5 sales by using



see the ached files for more detail


Yes, As Arjun said. Content is related to RANK but file is not related to RANK. And i request you to create All possible from UI only not the file so that some peoples don't have the license then they might easy to understand.

Creator II
Creator II

Hi Sunil,

You have updated wrong QVW file. Please upload the correct one.

Version history
Last update:
‎2019-06-21 06:13 AM
Updated by: