Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik doesn't load Excel data properly, how to solve?

Hi all,

Yesterday I've uploaded an Excel document and it worked perfectly fine. Today I tried to upload a newer version of this file and it only loads the first 10 rows of the document, it does the same thing with the original document now. As a test i created a completely new document with 100 rows containing only a number per row, this document was loaded perfectly fine. Even if I save the documents that don't work as a .txt file it only loads the first 10 rows. If I delete row 8-15 it will load row 1-7 and 16, 17 ,18. Is there something wrong with my file that it will only load the first 10 rows? Or does anyone know how to solve this issue in Qlik?

With kind regards,

Thijs

2 Replies
Colin-Albert

Perhaps if you post the test file and load script we can see what is happening.

Remember QlikView is case sensitive - have the column names or sheet names changed?

Not applicable
Author

Thank you for the trouble Colin but I solved it myself now. Just deleting all previous loadscripts solved te problem.

Thijs