Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 (1)
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?

 

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!