Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseBeginner
Contributor II

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!

1 Reply
mpc
Partner Ambassador

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


From Next Decision and mpc with love