80:20 Analysis Trend

[santlal0589]

Need to Show Month on Month Count of Sales Representative doing 80 % Business

  Example There are 1000 Sales Representative

In Apr 650 Sales Rep. Brings 80 %  of Apr Month  business and 350 are doing rest.

Ratio

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

80%

650

700

600

20%

350

300

400

Able to do for single Month using below code

Dimension:

=aggr(if((rangesum(above(sum(Sales),0,rowno()))

/ sum(total Sales))<=0.8),'80%','20%'),SalesRep)

Exp: Count(SalesRep)

Kindly suggest how to show monthly trend of 80:20 Analysis

[Anil_Babu_Samineni]

May be this?

Count({<Ratio = {'0.8'}>} SalesRep) : Count({<Ratio = {'0.2'} >} SalesRep)

[PrashantSangle]

can you share sample app??

mean time you can search for pareto analysis in community. might help you

Regards,

[PrashantSangle]

Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

check above thread.

[santlal0589]

@Prashant Sangle

getting issue in Month on Month Calculation

[PrashantSangle]

Hi,

is it possible share working app?

It will help us to provide correct solution.

Regards,

[qliksus]

You can  take the month dimension and create 2 expression for 80% and 20%

Dimension = Month

80%=count(aggr( rangesum(above(sum(Sales)// sum(total Sales),0,rowno())) )<=0.8),SalesRep))

20%=count(aggr( rangesum(above(sum(Sales)// sum(total Sales),0,rowno())) )>0.8),SalesRep))

[santlal0589]

Please find the attachment of the sample application.

It will be really helpful if you guys can implement the logic here.

so basically i want month as dimension and count of sourcingFOS who contribute to 80 % of the business (Amount) against each month.