Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: 80:20 Analysis Trend

May be this?

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

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

Re: 80:20 Analysis Trend

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.
Highlighted

Re: 80:20 Analysis Trend

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

check above thread.

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Contributor II
Contributor II

Re: 80:20 Analysis Trend

@Prashant Sangle

getting issue in Month on Month Calculation

Highlighted

Re: 80:20 Analysis Trend

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.
Highlighted
Specialist II
Specialist II

Re: 80:20 Analysis Trend

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

Highlighted
Contributor II
Contributor II

Re: 80:20 Analysis Trend

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.