2 Replies Latest reply: Jun 19, 2014 9:57 AM by Alan Farrell RSS

    Loading all rows from Excel including Blank rows

    Alan Farrell

      Hi All,

       

      I am loading an xlsx file into Qlikview that only contains 3000 lines of Data.

       

      However Qlikview seems to to load all rows including Blank Data, so when I reload the qvw I get over 1 million rows

       

      I have deleted formatting and all cells below the 3000 i need but it still loads over 1 million

       

      Any ideas