When I load your Excel file, I can see that you have 41 records in it, and that is also what QlikView has loaded.
But in a table box, QlikView will just display the 28 unique records, i.e. it will not show duplicates. But when you use the data in calculations (pivot table, bar chart, etc.), the calculation will be made on all 41 records.
If you create a field
RecNo() as RecordID
you will clearly see all records.