How to get top 80% of sales by Customer Type?

[Anonymous]

Hi,

I have 2 types of customer; Individual and Store.

How can I find out which Store generates 80% of the sales?

Thanks

Shirley

[sunny_talwar]

May be this can offer you some direction

Recipe for a Pareto Analysis – Revisited

[mdmukramali]

Hi,

Otherthan stalwar1‌ solution ,

                                             you can check the solution avalible in Whats New in Qlikview11  Demo Application .

in Product Sheet they impletement the same scenario.

PFA.

Thanks,

Mukram

[Anonymous]

Hi Sunny,

Somehow this doesn't work for me:

=Aggr(

    If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (Product,(=Sum({1} Sales),Desc))

    )

I am having problem generating sales by Store Customers only.

any idea on that?

Thanks

Shirley

[mdmukramali]

Hi,

Can you attach Sample data file.

Thanks,

Mukram.

[Anonymous]

Hi

Please see attached.

Shirley

[sunny_talwar]

I am having problem generating sales by Store Customers only.

What does this even mean? Can you elaborate? I saw that you have attached two sample files? What are those?

[mdmukramali]

Hi,

you have to Modify the Sunny Expression as per your requirement:

=Aggr(

    If(Rangesum(Above(Sum({1<CustomerType={'S'}>}Sales)/Sum({1<CustomerType={'S'}>}total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({{1<CustomerType={'S'}>}Sales)/Sum({1<CustomerType={'S'}>}total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (CustomerID,(=Sum({1<CustomerType={'S'}>} Sales),Desc))

    )

the alternative solution also added.

Kindly find the attached Application in which I have used sample data provided by you.

if you have any issue let me know.

Thanks,

Mukram.

[Anonymous]

HI Sunny,

when I use this

=Aggr(

    If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (Store_Name,(=Sum({1} Sales),Desc))

    )

I get this

[Anonymous]

HI Mukram,

thank you for your reply. I am using personal edition so I am not able to see your attached file.

I am trying to get the sales by customer type. SO the "CustomerID" does not work.

Shirley