# New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Partner - Contributor II

## 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?

1 Solution

Accepted Solutions

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

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

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

Partner - Contributor II
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?

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

``=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)``
Partner - Contributor II
Author

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

@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

Tags
Community Browser