People who bought this also bought that

[#1]

Hello all,

I'm trying to analyze our orders and get to know which product get sold together the most. I have two simple tables:

Table ORDERS:

- order_id

- date

Table ITEMS:

- order_id

- product_id

- quantity

- price

I would need to click on a specific product (product_id) and see which products got sold with it in most orders, ordered by total quantity.

Any help appreciated!

[#2]

Hi Michal,

When you load those tables, an automatic relation is formed in QlikView as the column names are same.

Create a straight table from Charts, add the dimensions and expression as Count(Quantity) which would display the count of each product.

Thanks,

Sai

[MarcoWedel · Accepted solution]

Hi,

one possible solution might be:

hope this helps

regards

Marco

[jyothish8807]

Hi Michal,

You can try grouping the product id with Order Date, so that by selecting the product ID you can know when it was sold and what else was sold on that date with same product.

Regards

KC

[#5]

Thank you all! Marco's solution was the closest to the one I was looking for, but I found this tutorial meanwhile and it works 100% for me:

http://www.quickqlearqool.nl/?p=965

Thanks again for your help!

[#6]

Hello Michael!

I am also interested in how you managed to make a Market Basket Analysis (identify what products are bought together). And the answers above do not satisfy me. Could you maybe help?

Many Thanks,

Marie