Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
coerdn
Partner
Partner

Top 3 Products Concentration

Hi together,

i want to build up a kpi for the top 3 export products concentration based on the whole product range. 

 

So i have Product A B C D E F and want to sum up the sum of sales for the top 3 and calculate the sales concentration for these three products.

 already sorted the products with a rank expression:

RANK(Sum({<[Product]={'Export'}>}[Sales]))

But i dont know how to build the sum dynamically for the top 3 products.

 

Can anybody help me?

many thanks in advance. 

1 Solution

Accepted Solutions
Kushal_Chawda

@coerdn  If you want in KPI then try below below expression

=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)

View solution in original post

5 Replies
Kushal_Chawda

@coerdn  did you try with limit dimension value to Top 3 option?

Screenshot 2020-09-21 233035.png

coerdn
Partner
Partner
Author

Hi kush,

thank you for your response. But i want to use a calculated kpi. which chart type do you use in your example?

Kushal_Chawda

@coerdn  If you want in KPI then try below below expression

=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)

View solution in original post

coerdn
Partner
Partner
Author

@Kushal_Chawda but then i get the sum of all products not only the top 3 products. 

Kushal_Chawda

@coerdn  It should give you sum of top 3 product only if you are using the same expression with correct field names as per your data