13 Replies Latest reply: Mar 2, 2015 10:19 PM by webster jayson sacluti RSS

    LEFT JOIN IN QLIKVIEW ?

      Hi,

      I am trying to join two tables in Qlikview but require all the data in Table 1 and only related data in Table 2.  Therefore in SQL this would require a straight forward left join however I can't seem to get this working in QV.

       

      Qualify*; 
      UnQualify CUST_ID ;
      
      DATA:
      LOAD "CUST_ID", 
           "123",
           "456" ,
      
      SQL SELECT *
      FROM "TABLE_1";
      
      
      Qualify*; 
      UnQualify CUST_ID ;
      
      LEFT JOIN (DATA)
      
      SALES:
      LOAD "CUST_ID", 
           "ABC",
           "EFG", 
      
      SQL SELECT *
      FROM "TABLE_2";
      
      

       

       

      I require all the values in CUST_ID in TABLE 1 - e.g. in the application if I run a simple COUNT(CUST_ID) it should show the total number of values in TABLE1 for CUST_ID.  However unfortunately this is not happening!  Where am I going wrong?