topic Re: Market Basket Analysis in QlikView

Market Basket Analysis

Mon, 28 Sep 2015 12:54:09 GMT

Hi all! Guys really need your help!!!

There are two tables with two columns: Product and Frequency of purchase; the Customer and Frequency of Purchases. When you choose the product number one shows the clients who bought them. You want to find the product number two at those customers who bought a product number one. Further, when we receive customers who purchased product number two, you need to know the third most important product from these customers.

In the end it should be a table with 6 columns: the main product - the frequency of purchases; supporting product - frequency of purchase; product support - frequency of purchase.

Thanks for any help and sorry for my bad English.

Re: Market Basket Analysis

pokassov — Mon, 28 Sep 2015 13:01:47 GMT

Hi!

It looks like your model doesn't have enough information for building report

Re: Market Basket Analysis

miguelbraga — Mon, 28 Sep 2015 14:21:30 GMT

Hi Marina,

I'm sorry to say, but you have no connection between the two tables, ence you can't do what you want. Provide us some form of connecting the data. What you have is two dimension tables, one for Products and the other for Customers, you really need a fact table like an Order table wich will contain the information of the client and what product or products the client bought. If you have thar table and provide us, then we can make you a solution for your problem.

Miguel

Re: Market Basket Analysis

Tue, 29 Sep 2015 07:04:33 GMT

Braga, excuse me for my old example. I added a new one. Please take a look.