How to display Top 5 records in straight table

[sridhar423]

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.

Please Any one help me out from this.

Thanks In Advance,

Sridhar

[Colin-Albert]

Use the Dimension Limits tab on the chart properties.

[maxgro]

different way to get top performers

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

[fvelascog72]

Hi,

Try this in expression:

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