Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sridhar423
Contributor III
Contributor III

How to display Top 5 records in straight table

HI ALL,

I have a table and it consists of 3 columns Country,City and Sales and i want to display the top 5 Country Sales.

Below is the  sample screen shot that i want to display.

Top5.PNG

Please Any one help me out from this.

Thanks In Advance,

Sridhar

3 Replies
Colin-Albert

Use the Dimension Limits tab on the chart properties.

limits.JPG

maxgro
MVP
MVP

different way to get top performers

https://community.qlikview.com/docs/DOC-5187

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try this in expression:

if(rank(sum(Sales))<=5,Sum(Sales))