Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
santlal0589
Contributor II
Contributor II

80:20 Analysis Trend

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.

RatioAprMayJunJulAugSepOctNovDecJanFebMar
80%650700600
20%350300400

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

7 Replies
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
PrashantSangle

can you share sample app??

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

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

check above thread.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
santlal0589
Contributor II
Contributor II
Author

@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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
qliksus
Specialist II
Specialist II

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
Contributor II
Contributor II
Author

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.