topic Re: Qlik Sense not loading entire flat file in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660852#M49593 <P>That worked like a charm. I changed the file type to csv, reloaded it and i am bringing in my full row count now.</P><P>Thank you for the quick response and help!</P> Thu, 26 Dec 2019 17:10:27 GMT JosephYoung 2019-12-26T17:10:27Z Qlik Sense not loading entire flat file https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660529#M49533 <P>Hello,</P><P>I am loading data via flat excel files and Qlik Sense is limiting the number of rows that are loaded.</P><P>I have a calendar count table with 126438 rows but Qlik Sense is only loading the data up to row 123050. I have no filters on in Qlik Sense.</P><TABLE border="1"><TBODY><TR><TD>IssueID</TD><TD>Date</TD><TD>OPEN_COUNT</TD><TD>CLOSED_COUNT</TD><TD>ACCEPTED_COUNT</TD></TR><TR><TD>1</TD><TD>2017-12-06 10:25:58</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>2018-01-08 06:00:17</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>2018-01-08 06:00:16</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>2018-03-23 09:30:07</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>3</TD><TD>2018-01-08 06:00:16</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>3</TD><TD>2018-02-08 06:02:52</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any help would be greatly appreciated.</P><P>Thanks,</P><P>Joseph</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:44:00 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660529#M49533 JosephYoung 2024-11-16T03:44:00Z Re: Qlik Sense not loading entire flat file https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660537#M49535 <P>What excel format is the file? if you save the file to csv, does it work as expected?</P><P>&nbsp;</P> Tue, 24 Dec 2019 16:36:09 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660537#M49535 lorenzoconforti 2019-12-24T16:36:09Z Re: Qlik Sense not loading entire flat file https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660852#M49593 <P>That worked like a charm. I changed the file type to csv, reloaded it and i am bringing in my full row count now.</P><P>Thank you for the quick response and help!</P> Thu, 26 Dec 2019 17:10:27 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-not-loading-entire-flat-file/m-p/1660852#M49593 JosephYoung 2019-12-26T17:10:27Z