2 Replies Latest reply: Jun 23, 2016 10:07 PM by Tamil Nagaraj RSS

    How to omit rows from an imported Excel document in Qlikview

    Alec Whitaker

      Hello,

       

      I am trying to import an Excel document into Qlikview. This Excel document has thousands of rows and rows 1-8 are solely used for titles. So, I want Qlikview to only look at row 9 and beyond. How can I import only rows x >=9?

       

      I've tried:

       

       

      Directory;
      LOAD B,
      C, 
      D, 
      E, 
      G,
      Y,
      AZ,
      BB,
      BC,
      BH,
      BI,
      FROM
      [Source]
      (ooxml, explicit labels, table is [Source])

      WHERE RowNo() >= 9;

       

      I've also tried:

       

      WHERE (G >= 9) but all this does is only take values in G that are greater than or equal to 9.

       

      So far, neither of these options is working. Any help is greatly appreciated.