topic Re: Top 10 in Pivot table in QlikView

Top 10 in Pivot table

Wed, 04 Jun 2014 15:10:32 GMT

Hi All,

I have a pivot table in that have Brand dimension in that have almost 30 brands is there

so now i want i pick top 10 Brands based on sales there is no dimension limit Tab for pivot table so can u suggest how we can restrict the top 10 brands in pivot table

thanks In Advance

Re: Top 10 in Pivot table

MayilVahanan — Wed, 04 Jun 2014 15:12:42 GMT

Try like this

=if(rank(Sum(Sales)) < = 10, Sum(Sales))

Re: Top 10 in Pivot table

Wed, 04 Jun 2014 15:26:33 GMT

You have to use a calculated dimension. You cant use sum and other aggregation function inside a IF statement like that. You have to use something like the below mentioned. In aggr I have used brand to aggregate, you have to mention all fields you are using as dimensions.

=AGGR(If(Rank(sum(Sales))<=10,Brand),Brand)