Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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.

Tags (2)
Community Browser