List of Top Combination of Products Ordered

[Anonymous]

Dear Community,

As a newbee, I am trying to create a list of Top Combination of Products which was ordered across many Orders.

Example using the following datasets:

Order 1:

Product A: Qty = 2

Product B: Qty = 1

Product C: Qty = 0

Order 2:

Product A: Qty = 4

Product B: Qty = 2

Product C: Qty = 0

Order 3:

Product A: Qty = 3

Product B: Qty = 1

Product C: Qty = 1

If I think of the analytical process, then I would go about doing the following:

1) Determine the Distinct Products:

Product A

Product B

Product C

2) Identify the possible Combination of products

Combination A = Product A and  Product B

Combination B = Product A and Product C

Combination C = Product B and Product C

3) Determine the applicable combinations, for each order, (where qty is bigger than 0)

Order 1:

Combination A = 1

Combination B = 0

Combination C = 0

Order 2:

Combination A = 1

Combination B = 0

Combination C = 0

Order 3:

Combination A = 1

Combination B = 1

Combination C = 1

4) Calculate the top combinations across orders by counting each combination

Combination A = 3

Combination B = 1

Combination C = 1

Conclusion is that Combination A was a top combination of all orders

How could I do this in QlikView?

I struggle to understand how I could apply my described approach in QlikView.

Or even if there is a better approach in QlikView given the data set as described above.

Hope someone can point me in the right direction...

Regards,

Flippie

[jwjackso]

If your data looks like this:

Orders:

load * Inline [

OrderNo,Product, Qty

1,A,2

1,B,1

2,A,4

2,B,2

3,A,3

3,B,1

3,C,1

];

All you want is a sum of the Qty by Product:

[Anonymous]

Hi Jerry,

Thanks for taking the time to help!

Your proposed solution will give me a list of top product.

What I am looking for is a list of top Combination of two products.

Example:

a Coke and a Chocolate together was the top combination purchased from my shop.

Just in my case, I have a list of several products under several orders to consider.

Am I making sense?