topic Re: distinct function is not working in foreign languages in QlikView

distinct function is not working in foreign languages

Mon, 23 Mar 2015 14:54:15 GMT

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.

Re: distinct function is not working in foreign languages

stigchel — Mon, 23 Mar 2015 15:13:47 GMT

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

Re: distinct function is not working in foreign languages

alexandros17 — Mon, 23 Mar 2015 15:14:29 GMT

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 ....

Re: distinct function is not working in foreign languages

stigchel — Wed, 25 Mar 2015 09:56:14 GMT

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.

Re: distinct function is not working in foreign languages

Wed, 25 Mar 2015 10:42:20 GMT

Sorry Piet for the delayed response..

Thank you so much for your help