Grouping of Top 10

[JohnFox]

Hi all.

I have built some metrics in my Qlik dashboard and I have a list of 30 or so manufacturers.  The manufacturer that I am after is in the middle of it or so and I would like to try and group the top 10 into one bucket, 2nd 10 into another bucket etc and may be add the bottom 10.

How is this metric built please?

Thank you!

[vinieme12]

use  a calculated dimension as below,  replace sum(Sales) with your measure for ranking top n

and Manufacturer  with your actual field name

=Aggr( If (rank(Sum(Sales),4,2)<=10,'Top 10'

,If (rank(Sum(Sales),4,2)<=20,'Top 10-20'

,If (rank(Sum(Sales),4,2)<=30,'Top 20-30' ))) , Manufacturer )