Create an input box to show top 10 values with respect to dimension in Qliksense

[Aspiring_Developer]

Hello All ,

I have below data set (sample set) :-

Product Grouping	Contact Flags	Orders
Dairy	AA	10
Farming	As	50
Machinery	BO	40

I've created a stack bar chart with below dimension and measure :-

Dimension - Product Grouping (Stack) | Dimension - Contact Flags (Bar)

Measure - count (orders)

Now , I want to create an input box that should show top 5 orders with respect to Product Grouping . 

How can I achieve it ? I tried using rank and aggregation but it did not worked . Can anyone please help me ?

Thanks in advance 

[Aspiring_Developer · Accepted solution]

Hello Everyone,

I was able to find the solution below :-

=Concat(Aggr(If(Rank(Sum(Orders))<= 5, Product_grouping&'('&Sum(Orders)&')'), Product_grouping), ',', Aggr(Rank(Sum(Orders)), Product_grouping))

Thanks