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