Number of Customer giving 80% of Sales in KPI Object

[divyanshraghuvanshi]

Hi All,

I need to show the Number of customer giving me 80% sales in KPI Object. 

[qv_testing]

like this

COUNT({<Customer={"$(=SUM(Sales)/SUM(Total Sales)>0.8"}>}Customer)

[Anil_Babu_Samineni · Accepted solution]

@divyanshraghuvanshi Perhaps this

Count(distinct Aggr((Num(Sum(Sales)/Sum(TOTAL Sales), '#.#0%'))=Num(0.8, '#.#0%'), customer))

[divyanshraghuvanshi]

Hi Anil Babu Samineni,

I  wanted to display name of that customers also in KPI . Can you please help me on that ?

Customer Name who has contributed to 80 % of Sales 

[Anil_Babu_Samineni]

@divyanshraghuvanshi Please have a look with these functions to get customer names as well.

FirstSortedValue - Script Function | Qlik Sense for Windows Help

Concat - script function | Qlik Sense on Windows Help