
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rows of Data not pick up by Qlik Sense
Has anyone encountered this issue before?
I manually calculated the number of rows from a raw Excel file and found 8,253 entries under the category: "No, I was not offered a position, but the internship(s) / work attachment(s) / work study scheme(s) has helped me obtain a job in other ways."
However, after loading the data into Qlik Sense, the system only reports 8,235 rows—so, 18 rows are missing.
To troubleshoot, I created a table in Qlik Sense, applied the same filters, and compared it with the raw data. I was able to pinpoint the 18 missing rows, but there doesn't seem to be anything different about them—they appear identical to the others.
I'm stumped as to why Qlik Sense isn’t recognizing these rows. Has anyone faced a similar discrepancy before? Any insights or suggestions would be greatly appreciated!
- Subscribe by Topic:
-
Data Load Editor
-
filter
-
General Question
-
Qlik Cloud
-
Qlik Sense
-
Script
-
Set Analysis
-
Visualization

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If rows are identical to another one, only one we'll be displayed. To test this, you can load them with a RowNo() calculated field, and adds it to your report. If RowNo() is 8,253 all data are loaded, and you flag duplicate rows.
Else more investigation are needed.
Kind regards
