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

Aspiring_Developer — Mon, 08 Jan 2024 12:16:55 GMT

Hello All ,

I have below data set (sample set) :-

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

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

Aspiring_Developer — Mon, 08 Jan 2024 14:33:14 GMT

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