2 Replies Latest reply: Jun 9, 2016 3:23 AM by Thijs Hoff RSS

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

    Thijs Hoff

      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