count & count distinct function giving the same result on alphanumeric column

[vish123]

Hi Team,

I am facing strange thing in Qlik Sense where count & count distinct giving same results on a alphanumeric number column. Can you please suggest a solution. does anyone faced the similar case in your development ? 

Please let me know in case of more details.

Thanks

Vishnu

[Qlik_Eric_Thomas]

Do you have a sample .QVF that demonstrates this issue? It's not impossible for Count and Count Distinct to show the same number if the underlying data matches that scenario.

[MarcoWedel]

Can you describe your expected results of the count function based on some sample data? 

[vinieme12]

You most likely have unique values in the field and table 

for example in a normalized employee table count(EmployeeID) and count(Distinct EmployeeID) will be same

[vish123]

Hi Vineeth,

Thanks for your reply.

No the column does have duplicates in it. I have exported to data to excel and found this.

Even i have tried as below thinking that column might have trailing and leading spaces but did not work.

----> count( distinct trim(column))

Thanks

Vishnu

[tresesco]

Can you try to load the exported (to excel) data again in qlik and see if the behavior is same or not? If you still see the same issue, please try to share the excel here, so that we can give a try at our end.

[vish123]

Hi All,

I have found the issue. I have to convert whole column to lower case which worked. Thanks all for your help.

Actually alphanumeric number has some capitals and lower letter in it which caused this issue but now it got resolved. 

Thanks

Vishnu