If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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:
But i dont know how to build the sum dynamically for the top 3 products.
Can anybody help me?
many thanks in advance.
@coerdn If you want in KPI then try below below expression
View solution in original post
@coerdn did you try with limit dimension value to Top 3 option?
thank you for your response. But i want to use a calculated kpi. which chart type do you use in your example?
@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