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

[#1]

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

OrderID	ProductID
1000	500
1000	501
1000	508
1000	506
1001	500
1001	504
1002	500
1002	508
1003	506

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 ?

[marcus_sommer]

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