How to apply market basket analysis / association

2019-09-15 00:54发布

问题:

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

[ https://www.dropbox.com/s/mu1bz1wbrojou4t/AssociationRule.zip ]

Thanks everyone in advance!