topic Pivot table - Top 20 in QlikView

Pivot table - Top 20

Wed, 22 Sep 2010 12:59:28 GMT

I want to show top 20 in a pivot table. So within the other dimensions.
e.g.: per salesperson -> per articlegroup -> Top 20 articles

Pivot table - Top 20

renjithpl — Thu, 23 Sep 2010 06:47:30 GMT

hope sorting will do,

try sort -> numeric value - descending

thanks

Pivot table - Top 20

Thu, 23 Sep 2010 06:53:49 GMT

Hi,

You can use the rank function in calculated dimension to show top 20 Salesperson. Below is the sample:

IF(AGGR(RANK(SUM(Sales)), Salesperson) <= 20, Salesperson)

Please check the checkbox " Suppress When Values is Null" for this calcualted dimension under Setting for Selected Dimension in Dimensions tab.

Please let me knw if you have any more query in this regard.

Pivot table - Top 20

Thu, 23 Sep 2010 06:59:21 GMT

Hi,

Further to more specific to your requirement you can use the below one which will show "per salesperson -> per articlegroup -> Top 20 articles" using the rank function in calculated dimension for article:

IF(AGGR(RANK(SUM(Sales)), salesperson, articlegroup, article) <= 20, article)

Please check the checkbox "Suppress When Values is Null" for this calculated dimension under Setting for Selected Dimension in Dimensions tab.

Please let me know if you have any more query in this regard.

Dhananjay (DJ)

Pivot table - Top 20

swarup_malli — Wed, 24 Aug 2011 01:23:30 GMT

Dhananjay Mishra,

Thank you , it worked for me.