4 Replies Latest reply: Feb 24, 2011 8:23 AM by Reignfire RSS

    Can't get my data right.

      hi,

      i have 2 datatables, one with handled numbers and one with unhandled number. when i load them seperatly i get the right total of numbers but when i load them both the total of handled numbers is still right but the total of unhandled numbers ain't right anymore.

      i know that the data is handled if the transmit number has a value, if its just a space its unhandled.

       

       

       

       



       

       

       

      Directory;
      LOAD

       

      TRANSMITNR
      if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
      ARTNR,
      ARTDEC,
      EPIKIND,
      AMOUNT
      FROM
      [Data\UNHANDLED\tab201102.xls]
      (
      biff, embedded labels, table is [Sheet 1$]);

      Directory;
      LOAD
      TRANSMITNR,
      if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
      ARTNR,
      EPIKIND,
      VSC_MONTH,
      CLASS,
      AMOUNT
      FROM
      [Data\HANDLED\tab200923.xls]
      (
      biff, embedded labels, table is [Sheet 1$]);

      how come i only get the right total amount of handled data and not of the unhandled data if i run this script?

      please help.





       

       

       

       

       



        • Can't get my data right.
          Dennis Hoogenboom

           

          I am not sure but I think Qlikview combines the data when you use the same field names, so it will just add it togehter.

          Try to load it like this: (just to see what happens)


          QUALIFY *;

          Unhandled:
          Unqualify TRANSMITNR;
          LOAD
          TRANSMITNR
          if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
          ARTNR,
          ARTDEC,
          EPIKIND,
          AMOUNT
          FROM
          [Data\UNHANDLED\tab201102.xls]
          (biff, embedded labels, table is [Sheet 1$]);

          Handled:
          Unqualify TRANSMITNR;
          LOAD
          TRANSMITNR,
          if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
          ARTNR,
          EPIKIND,
          VSC_MONTH,
          CLASS,
          AMOUNT
          FROM
          [Data\HANDLED\tab200923.xls]
          (biff, embedded labels, table is [Sheet 1$]);
          UNQUALIFY*;