topic Re: Restrict a chart of type pivot table to top 10 rows? in QlikView

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

Thu, 04 Oct 2012 07:08:36 GMT

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

thomas_skariah — Fri, 05 Oct 2012 08:31:57 GMT

Hi Bimalhaz,

You can get idea from the following link

Regards,

Tom

jagan — Fri, 05 Oct 2012 11:05:08 GMT

Hi,

Hope attached file helps you.

Regards,

Jagan.

Fri, 05 Oct 2012 13:06:22 GMT

Dear its qlikview 11 defualt property named >> dimension limits

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

Fri, 30 May 2014 06:56:06 GMT

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

Mon, 02 Jun 2014 17:36:12 GMT

you should use Year in your aggr exp

aggr(rank(sales),year,Country)