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: 
Not applicable

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

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

5 Replies
thomas_skariah
Creator III
Creator III

Hi Bimalhaz,

You can get idea from the following link

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

Regards,

Tom

jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope attached file helps you.

Regards,

Jagan.

Not applicable
Author

Dear its qlikview 11 defualt property named >> dimension limits

or it aslo covered in Chart properties >> presentations>>follow the attachments for both examplesTop ten values 2.jpgTop ten values.jpg

Not applicable
Author

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

sales.PNG.png

so I added this expression in dimensions

Capture.PNG.png

and as a result I have

Capture.PNG.png

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

Not applicable
Author

you should use Year in your aggr exp

aggr(rank(sales),year,Country)