distinct function is not working in foreign languages

[#1]

Hi Team,

Qlikview and Excel is giving  different results when using distinct function for a column having foreign language entries.

In Qlikview distinct is giving 12381(Column C) rows where as excel when removing the duplicates giving 12367(Column B).

Please let me know which is the correct output.

For your reference attaching the sample input Data (Column A) and results.

Thanks and Regards,

Sreehari Satheesan.

[stigchel · Accepted solution]

It seems that the Excel remove duplicates function is case insensitive, and QlikView is case sensitive. Example:

AGERIT S.R.O.

Agerit s.r.o.

Are two distinct values for Qlikview, but excel removes one of them when removing duplicates.

Depending on what you consider correct, you can do an Upper(MyField) load of this field in QV and you will probably end up with the same distinct count as in excel

[alexandros17]

This is because qlik count twice the same row Ex.

AGERIT S.R.O.

Agerit s.r.o.

Because upper and lower cases are distinct values while Excel consider them the same ....

[stigchel]

Has this answered your question? If so, can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.

[#5]

Sorry Piet  for the delayed response..

Thank you so much for your help