Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rajuamet
New Contributor II

Market Basket Analysis - How to find frequency of Co-Occurrence.

I am stuck up in finding the co-occurrence. Please help me to solve this. See the attachment for details.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Market Basket Analysis - How to find frequency of Co-Occurrence.

Try: count({<ItemCode=e(ItemCode), InvoiceNo=p({<ItemCode=p(ItemCode)>}InvoiceNo)>}DISTINCT PhoneNo)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Market Basket Analysis - How to find frequency of Co-Occurrence.

Try: count({<ItemCode=e(ItemCode), InvoiceNo=p({<ItemCode=p(ItemCode)>}InvoiceNo)>}DISTINCT PhoneNo)


talk is cheap, supply exceeds demand

View solution in original post

rajuamet
New Contributor II

Re: Market Basket Analysis - How to find frequency of Co-Occurrence.

Excellent!!! Thanks Gysbert Wassenaar.