Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Loading all rows from Excel including Blank rows

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

2 Replies
joshabbott
Creator III
Creator III

I've had to do this before:

1 - Open a new instance of excel

2 - Copy and paste the data part from your 'data' spreadsheet into your new spreadsheet

3 - Save your new spreadsheet

4 - Try loading your new spreadsheet

Maybe it will work for this situation too.  Good luck!

rustyfishbones
Master II
Master II
Author

Thanks Josh,

I realize I can do this but if I get an updated file I don't want to have to copy and paste each time.

I found an issue on line 1048418 just before the end of the excel file that seems to be a Table in Excel so I removed it and it worked

Thanks for your help though

Alan