8 Replies Latest reply: Oct 26, 2011 2:18 PM by Damon Boynton RSS

    Issue with Multiple Overlapping Joins

      I'm new to qlikview and have found myself stumped in one of my projects.

       

      I'm trying to join 3 tables that include a list of names and data recorded by month.  I've included and example below.  The issue I'm having is that the list of names aren't the same every month and when Smith is skipped in TableB it creates a null value in Apr that prevents the record in TableC from being joined to Table A.  This creates an unwanted duplicate record for Smith.  Is there a way to prevent this?

       

      TableA:

      LOAD * INLINE [

          Name, Jan, Feb, Mar

          Abe, 2, 3, 5

          Smith, 5, 2, 6

          Joe, 3, 2, 4

          Sal, 4, 3, 1

      ];

       

       

      TableB:

      Outer Join (TableA)

      LOAD * INLINE [

          Name, Feb, Mar, Apr

          Abe, 3, 5, 4

          Joe, 2, 4, 4

          Sal, 3, 1, 3

      ];

       

       

      TableC:

      Outer Join (TableA)

      LOAD * INLINE [

          Name, Mar, Apr, May

          Abe, 5, 4, 1

          Smith, 6, 3, 3

          Joe, 4, 4, 4

      ];