I have unique values in my excel spreadsheet (verified by removing the duplicate values and also checking for unique records) although loading these values in qlikview and using distinct, qlikview still seems to find duplicate values?
My data is a combination of numbers and alpha numeric values.
Unfortunately I'm not able to post the data due to security issues.
Basically I have just one column in a spreadsheet which I'm loading in to a blank QVW. Doing a count of this column in qlikview - count ( fieldname), I get a few extra values then when I export this field in to a excel spreadsheet. It seems while exporting to a xls, qlikview is able to remove some dupes, although there aren't any dupes when just checking for uniqueness in the excel spreadsheet.
If you want to compare the data in qlik with the excel-data and the export-data you need to take tablebox for it which also contained a unique record-identifier which you could create within qlik per recno() and rowno() which also are a good indicator if a distinct or any where-clause effects the number of records.