Restrict a chart of type pivot table to top 10 rows?

[#1]

How can I restrict or display a chart of type pivot table to top 10 rows? Thanks

[thomas_skariah]

Hi Bimalhaz,

You can get idea from the following link

http://community.qlik.com/message/256499#256499

Regards,

Tom

[jagan]

Hi,

Hope attached file helps you.

Regards,

Jagan.

[#4]

Dear its qlikview 11 defualt property named >> dimension limits

or it aslo covered in Chart properties >> presentations>>follow the attachments for both examples

[#5]

Good evening friends

I am facing  the same problem and I need your help

I try to display the first 10 sales per country in a Pivot table

so I added this expression in dimensions

and as a result I have

as you can see  for 2010 it gives a result  USA-> France-> germany  and the logical order is USA-> France-> UK

  why?

Thank you for your answers

[#6]

you should use Year in your aggr exp

aggr(rank(sales),year,Country)