topic How to display Top 5 records in straight table in QlikView

How to display Top 5 records in straight table

sridhar423 — Wed, 03 Jun 2015 14:07:41 GMT

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 — Wed, 03 Jun 2015 14:09:26 GMT

Use the Dimension Limits tab on the chart properties.

maxgro — Wed, 03 Jun 2015 14:16:02 GMT

different way to get top performers

fvelascog72 — Wed, 03 Jun 2015 14:18:59 GMT

Hi,

Try this in expression:

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