Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lefzam00
New Contributor II

Pareto KPIs

Hi

I am trying to calculate in a single KPI with the number or products that contribute 80% of the sales.

I currently have the following formula which however does not work.

Count(if(Aggr(Rangesum(Above(Sum(Sales)/Sum(Total Sales),0,Rowno())),Product)<=0.8,Product))

ProductSales
Product 110
Product 29
Product 38
Product 47
Product 56
Product 65
Product 74
Product 83
Product 92
Product 101
1 Reply

Re: Pareto KPIs

May be check this out:

ABC Analysis in Qlikview

Community Browser