Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to find out most popular product combination (n > 2)?

Hello!

Trying to figure out how to find a combination of the most purchased goods together . Number of products in combination - from 3 to 7. That is, I want to know what 3 (or 4,5,6,7 ) of goods most often present in one order.

I have a table with the order numbers and product numbers, like this

OrderIDProductID
1000500
1000501
1000508
1000506
1001500
1001504
1002500
1002508
1003506

For n = 3 , for this example, the solution will be "500, 508, 506". Because two orders contain these products.

Is there any function in Qlik Sense to solve this problem ?

1 Reply

Re: How to find out most popular product combination (n > 2)?

Try as start something like this:

PoductCombines:

Load OrderID, concat(ProductID, ', ', ProductID) as CombinedProducts From xyz Group By OrderID;

Then you could use CombinedProducts as dimension in a chart and make a count(OrderID).

- Marcus

Community Browser