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

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

    Boris Chigirintsev

      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 ?