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