Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Gysbert_Wassenaar

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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Excellent!!! Thanks Gysbert Wassenaar.