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: 
Topaz2021
Contributor
Contributor

Not uploading all data from Excel

When I upload data from Excel I get only partial data in the app. 

For example, I have 150 records in 1 model, and in Qlik Sense I can see only 22 records .

Any suggestions? 

1 Reply
Or
MVP
MVP

Check that there are no blank rows in the middle of your data, for starters. If that's not the issue, try copying the data to a fresh sheet to make sure there isn't something wrong with the current one. 

If it keeps cutting off at the same point, check the line where it cuts off for anything unusual that may cause Qlik to stop on that line.

Also, if you're comparing your Excel data to a Qlik front-end table, keep in mind that in tables and pivots Qlik will merge identical lines. You can see if one Qlik line represents multiple Excel lines by adding e.g. Count(FieldFromTable) as a measure.