Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

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

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

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

Thijs