Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

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

Hi,

I have 2 types of customer; Individual and Store.

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

Thanks

Shirley

12 Replies
MVP

May be this can offer you some direction

Recipe for a Pareto Analysis – Revisited

Specialist III

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
Not applicable
Author

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

Specialist III

Hi,

Can you attach Sample data file.

Thanks,

Mukram.

Anonymous
Not applicable
Author

Hi

Shirley

MVP
 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?

Specialist III

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
Not applicable
Author

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
Not applicable
Author

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

Community Browser