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: 
qlikeers
Creator II
Creator II

Pareto analysis for sales

For some time I have been trying to figure out how to calculate a pareto for sales.

I have a sales table:

InvoiceDateProductIdProductGroupSumOfSales
date1productid1productgroup1100
............

 

I would like to check:
1) How many products generate 80% of sales for a given day?
2) How many products generate 80% of sales for a given day and a given product group?

 

Can you suggest the easiest way to count it?

Labels (4)
9 Replies
sunny_talwar

Have you already checked this?

Recipe for a Pareto Analysis – Revisited 

qlikeers
Creator II
Creator II
Author

Thanks! I will check!

I see there is the chart. I need a table with the result.

1)

DateNumber of product (generate 80% sal.)
......

 

 

2)

DateProductGroupNumber of product (generate 80% sal.)*
.........

 

 

*for each day and each group

sunny_talwar

Logic stays the same for Table or chart

qlikeers
Creator II
Creator II
Author

Thanks, I used the formula and it seems to work.

But I need a different result (count). And I don't really have an idea how to change it.
I must have:
1) How many products make 80% of sales every day?
2) How many products in a given group make 80% of sales on a given day?

 

PS. On a large amount of data this formula (Pareto class) is converted quite a long time - which can be tedious.

sunny_talwar

You will have to share some data where we can see what you have. It would also help to know the output you expect to see from the sample data shared

qlikeers
Creator II
Creator II
Author

I attach a sample data.

sunny_talwar

Based on this sample, what exactly are you looking to get? specific numbers based on the input file will make it easy to understand

qlikeers
Creator II
Creator II
Author

@qlikeers wrote:

Thanks! I will check!

I see there is the chart. I need a table with the result.

1)

DateNumber of product (generate 80% sal.)
......

 

 

2)

DateProductGroupNumber of product (generate 80% sal.)*
.........

 

 

*for each day and each group


Btw.

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

Does not include the day (and any groups).

qlikeers
Creator II
Creator II
Author

And is it possible to count it directly in LoadScript?