Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JosephYoung
Contributor
Contributor

Qlik Sense not loading entire flat file

Hello,

I am loading data via flat excel files and Qlik Sense is limiting the number of rows that are loaded.

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.

IssueIDDateOPEN_COUNTCLOSED_COUNTACCEPTED_COUNT
12017-12-06 10:25:58100
12018-01-08 06:00:17010
22018-01-08 06:00:16100
22018-03-23 09:30:07010
32018-01-08 06:00:16100
32018-02-08 06:02:52010

 

Any help would be greatly appreciated.

Thanks,

Joseph

 

Labels (3)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

What excel format is the file? if you save the file to csv, does it work as expected?

 

View solution in original post

2 Replies
lorenzoconforti
Specialist II
Specialist II

What excel format is the file? if you save the file to csv, does it work as expected?

 

View solution in original post

JosephYoung
Contributor
Contributor
Author

That worked like a charm. I changed the file type to csv, reloaded it and i am bringing in my full row count now.

Thank you for the quick response and help!