topic Re: 80:20 Analysis Trend in QlikView

80:20 Analysis Trend

santlal0589 — Thu, 16 Nov 2017 07:12:06 GMT

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

Re: 80:20 Analysis Trend

Anil_Babu_Samineni — Thu, 16 Nov 2017 07:15:47 GMT

May be this?

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

Re: 80:20 Analysis Trend

PrashantSangle — Thu, 16 Nov 2017 07:17:26 GMT

can you share sample app??

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

Regards,

Re: 80:20 Analysis Trend

PrashantSangle — Thu, 16 Nov 2017 07:18:23 GMT

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

check above thread.

Re: 80:20 Analysis Trend

santlal0589 — Thu, 16 Nov 2017 09:24:53 GMT

@Prashant Sangle

getting issue in Month on Month Calculation

Re: 80:20 Analysis Trend

PrashantSangle — Thu, 16 Nov 2017 09:50:31 GMT

Hi,

is it possible share working app?

It will help us to provide correct solution.

Regards,

Re: 80:20 Analysis Trend

qliksus — Thu, 16 Nov 2017 10:14:41 GMT

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))

Re: 80:20 Analysis Trend

santlal0589 — Thu, 16 Nov 2017 10:39:57 GMT

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.