0 Replies Latest reply: Mar 13, 2015 12:12 PM by Peng Si Hua RSS

    Market Basket Analysis

      Currently I am trying to follow this tutorial for Market Basket Analysis in QlikView

       

      However it works well for their own sample datasets. when I am trying my own set of data it does not work.

      This part did not work :

      Order Quantity if(ProductName=MBProductName,0,Count(DISTINCT %%MarketBasket)) 

       

      Order quantity show 4 which is correct.

      But when I am trying out .. it start counting the number of product in the transaction and not find out the market baskets.

      The link follow include myQlikView and Tutorial Qlikview :

      [https://www.dropbox.com/s/7i2mslsm61kgj9n/TutorialQlikView.qvw ] [https://www.dropbox.com/s/ffz9xw6lfo6m4gq/MyMarketBasketAnalysis.qvw ]

      I knew it did not work as I have check the Excel by filtering 2 products.

      Big Guy Men's Air Tuned Sirocco Shoes (productID: 220200100099) and Power Dmx Wide Shoes (productID :220100700038)

      Power Dmx Wide Shoes shows 736 when it does not have any transactions together with Big Guy Men's Air Tuned Sirocco Shoes.

      It seems like just counting the number of transactions that have Power Dmx Wide Shoes and it does not check with the MB product column.

      enter image description here

      Can anyone help me spot the mistake that I have made? Thanks in advance.