Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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)