1 Reply Latest reply: Jan 24, 2015 12:42 PM by Marcus Sommer

# 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 ?

• ###### 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