Unexpected sort order

[paolo_cordini]

Hello, 

I faced this apparently unexpected sort order. I guess there is an explanation but I'm having an hard time trying to find it...

Any suggestion?

Regards
Paolo

[marcus_sommer]

Does it mean that without an expression and with a left(Field, 14) the sorting is wrong and differently to applying left(Field, 13) ?

[Or]

https://community.qlik.com/t5/QlikView-App-Dev/Sorting-Alphanumeric-values/td-p/141351

I think this may be a variant of the situation described in that link, where Qlik is breaking the string up into bits and trying to sort those numerically.

And it turns out I vaguely remember reading posts about stuff from 15 years ago. Yeesh, feels old.

[paolo_cordini]

OK, I opened a support case, just to confirm it is working as designed.

Thanks