Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks everyone in advance!
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.
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 !!