topic SV:Chinese characters sorting in QlikView

Chinese characters sorting

Mon, 15 Nov 2010 08:57:23 GMT

Hi! I'm from china!

Recently I found an interesting thing.I have two operation system,one is English and the other is Chinese! When I do the sort operation with the same qvw file in this two system.I got a different thing.

pic 1:this one is in the english system and is wrong

Pic 2: this is in the chinese system and is right.

Can anyone help me ?

SV:Chinese characters sorting

Mon, 15 Nov 2010 11:03:06 GMT

Don't think you can expect chinese charachters to be sorted correctly in an english based setting. Perhaps you could explicitly map the sort order in the loading part of the script.

/Michael

SV:Chinese characters sorting

johnw — Tue, 16 Nov 2010 01:32:36 GMT

On my English copy of QlikView, it says that sorting is done by the ASCII standard. That wouldn't work for Chinese Characters, which I assume are in UTF-8?

Now, I would have THOUGHT that QlikView would be smart enough to realize that if you loaded a table in UTF-8, that you want to sort by UTF-8 as well. But maybe it isn't, and the help text seems to indicate that it isn't. I suppose it isn't technically a bug in that case, since it is working as stated, but it sure seems like a missing feature!

Michael's solution sounds reasonable to me. As I interpret it, you would add a "MajorCategoryNameSequence" field during the load. As long as you do the load in the Chinese system, I would expect you to be able to establish this field correctly. Then I believe you should be able to enter "MajorCategoryNameSequence" as the default sort expression for "MajorCategoryName". I suspect it would work.

Edit: Or you could use the dual() function to assign the sequence number directly to the MajorCategoryName. Then just sort by numeric instead of by text value.

SV:Chinese characters sorting

Mon, 29 Nov 2010 04:12:52 GMT

Thanks John!

This is real interesting that I got correct in my Chinese system but wrong in the English system with the same qvw file!