6 Replies Latest reply: Dec 1, 2011 9:03 AM by Marc Zabal RSS

    Displaying only Unique combinations

      Hello All,

       

      I have been trying to create a .qvw to display the unique pairs or combinations or items in a table.

       

      The table looks as follows:

       

      Basket, Item

      1,M

      1,E

      2,E

      2,B

      3,M

      3,B

      4,M

      4,E

      5,M

      5,E

      5,B

       

      What I have done is loaded the table twice and then inner joined the two tables on basket. 

       

      Combos:

      Load

      basket,

      item as item1

       

      inner join

       

      Load

      basket,

      item as item2

       

      This gives me all of the possible combinations with one issue.  I get the M,E combination as well as the E,M combination.  So when I put this into a Pivot table I get 2 of the same combination with the same count.  I need to exclude the duplicate either in the load or in the chart.

       

      Thanks

       

      Marc