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!
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…