Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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.
Thanks
can you post your data?
HI,
If you have used DISTINCT keyword while loading , then it will find the distinct combinations ,
and it will take a bit more time than loading without distinct.
try this
=Only(Distinct Fieldname)
Hi Jonathan
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.
Hi Nitin
I'd like to use distinct in the set analysis. Please see my response above to Jonathan for further update.
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.
- Marcus