Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to apply Market Basket (association rule) in qlikView?

I want to use Association rule in Qlikview to find out the Best Product Combination. But Im not technically strong in QlikView. Can anyone provide tutorials or can kindly teach me how to use the features in qlikview to performed the association rule.(Time slice is flexible if possible. )

And now currently , I'm trying with this tutorial for Market Basket analysis

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

But it did not count the number of customer for the same purchase behaviour . (within 1 month )

Data I have

Order table:

Order_ID, Order_date, Product_ID, customer_ID, Quantity

Product table:

Product_ID, Product Name

The following dropBox link is a sample datasets

Dropbox - AssociationRule.zip

Thanks everyone in advance!

2 Replies
Not applicable
Author

Hi Peng,

Do you mind explaining a little bit more on what the requirement is.  What is it that you want to calculate (like # of customers for each product?) . It would really help if you could elaborate a little more.

Not applicable
Author

Currently I am trying to use qlikview to do Market Basket analysis to find out the best product mixed .

and I have tried [ http://www.quickqlearqool.nl/?p=965 ]

How can I improve this dashboard to add in a Venn digram to show the relationships for the product combination [count the number of Customer who buy milk will buy Bread within a certain duration].

The following dropBox link is a sample datasets with the Venn Diagram :

[ https://www.dropbox.com/s/s2z2ikgyr436gxm/MarketBasketwithVennDiagram.zip ]

Thanks in advance !!