topic Re: count & count distinct function giving the same result on alphanumeric column in App Development

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

vish123 — Wed, 11 Jan 2023 14:55:20 GMT

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

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

Qlik_Eric_Thomas — Wed, 11 Jan 2023 15:27:51 GMT

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.

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

MarcoWedel — Wed, 11 Jan 2023 19:32:08 GMT

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

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

vinieme12 — Thu, 12 Jan 2023 02:14:26 GMT

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

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

vish123 — Thu, 12 Jan 2023 04:51:12 GMT

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

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

tresB — Thu, 12 Jan 2023 05:23:00 GMT

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.

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

vish123 — Thu, 12 Jan 2023 05:27:29 GMT

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