Discussion board where members can get started with Qlik Sense.
I am quite new to qliksense and I have noticed already some discrepancies between excel and qliksense.
Whenever I import a csv file into qliksense, I get a different number of distinct values than the one I get from excel when I remove duplicates. And it's not just a couple, but thousands.
Do you know if I am missing something during the process? Am I doing anything wrong?
Go to Solution.
Check the spelling of your csv file. Qlik Sense is case sensitive. For instance, excel will identify "name" and "Name" as duplicate values but Qlik will identify them as distinct values.
can you attach some data (a portion of your file) ?
also, it will be interesting to see via screen shots the difference you have between excel and Qliksense
Hi, I don't seem to find the place for attaching files..
When you open the thread and start to write, on the right there is a link to advanced options, click on it and from there you can attach everything you want
Please check the below link -
Uploading a Sample
Thanks for the help.
Attached you can find the file I am struggling with.
It has 6145 distinct values according to qliksense, but when I remove duplicates in excel, I am left with 4422 values...
Thanks, Carlos. It seems that this is the problem indeed with this file. Now that I know the issue, I can fix it
Awesome Ancuta, I'm glad it was a simple fix.