Discussion board where members can get started with QlikView.
I'm trying to analyze our orders and get to know which product get sold together the most. I have two simple tables:
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!
Go to Solution.
one possible solution might be:
hope this helps
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.
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.
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:
Thanks again for your help!
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?