Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

People who bought this also bought that

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!

1 Solution

Accepted Solutions
Highlighted

Re: People who bought this also bought that

Hi,

one possible solution might be:

QlikCommunity_Thread_137437_Pic2.JPG.jpg

QlikCommunity_Thread_137437_Pic1.JPG.jpg

QlikCommunity_Thread_137437_Pic3.JPG.jpg

hope this helps

regards

Marco

5 Replies
Not applicable

Re: People who bought this also bought that

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

Highlighted

Re: People who bought this also bought that

Hi,

one possible solution might be:

QlikCommunity_Thread_137437_Pic2.JPG.jpg

QlikCommunity_Thread_137437_Pic1.JPG.jpg

QlikCommunity_Thread_137437_Pic3.JPG.jpg

hope this helps

regards

Marco

jyothish8807
Honored Contributor II

Re: People who bought this also bought that

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

Best Regards,
KC
Not applicable

Re: People who bought this also bought that

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!

Not applicable

Re: People who bought this also bought that

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