display top n in pivot table

Fri, 30 May 2014 00:28:02 GMT

Good evening friends

I am facing a 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 and it

USA-> France-> UK why?

Thank you for your answers

Re: display top n in pivot table

Gysbert_Wassenaar — Mon, 02 Jun 2014 17:49:27 GMT

Your expression aggregates only per country so you get the ranking of countries without considering the year dimension (which is not in the aggr definition). That's why you see the same three countries listed for each year.

topic Re: display top n in pivot table in QlikView

display top n in pivot table

Re: display top n in pivot table