2 Replies Latest reply: Dec 4, 2011 10:41 AM by Robert Hutchings RSS

    Null to appear when two tables are joined not blank

    Robert Hutchings

      This si just an example to try and achieve what I can not achieve with a much larger file

       

      Script is shown below

       

      Ive tried every option I can from the manuals but this is the best so far that I can achieve

       

       

      I just want null to appear instead of blank in the LU column (so that I can select by null. Blank of course is not a selectable field)

       

      I have just been dumpinmg into excel and sorting but can be done in qlikview?

       

      SET ThousandSep=',';SET DecimalSep='.';SET MoneyThousandSep=',';SET MoneyDecimalSep='.';SET MoneyFormat='£#,##0.00;-£#,##0.00';SET TimeFormat='hh:mm:ss';SET DateFormat='DD/MM/YYYY';SET TimestampFormat='DD/MM/YYYYhh:mm:ss[.fff]';SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';SET NullValue= 'Null';

      abc:LOAD

      Ser_Num

      FROM
      D:\QlikView\TestSerialRH.xlsx
      (
      ooxml, embedded labels, table is Sheet1);


      xyz:

      LEFT JOIN

      LOAD Ser_Num,
          
      LUFROM
      D:\QlikView\TestSerialRH.xlsx
      (
      ooxml, embedded labels, table is Sheet2);

       

      NULLASVALUE LU;

      lOAD LU,Ser_Num

      Resident abc;