topic Unexpected sort on a Calculated Dimension: [Line] & ' ' & [Label] in QlikView

Unexpected sort on a Calculated Dimension: [Line] & ' ' & [Label]

Thu, 14 Jan 2016 23:27:45 GMT

Please see attached Qlikview.

Simple Load Script:

Simple List Boxes, the third of which doesn't sort how I expect.

Now I can think of various confounding factors:

And so I can workaround and achieve my expected behavior

But I can't wrap my head around why these things (might) cause the unexpected the results.

Thu, 14 Jan 2016 23:56:06 GMT

By the way, I say I "expect" Text(Line) to sort like this:

13a

13b

But if it were lexicographic sorting, wouldn't it be:

13a

13b

As demonstrated here in my Chrome Javascript console:

l=['1a','1b','2','3','4','5','6','7','8','9','10','11','12','13a','13b']

["1a", "1b", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13a", "13b"]

l.sort()

["10", "11", "12", "13a", "13b", "1a", "1b", "2", "3", "4", "5", "6", "7", "8", "9"]

Mon, 15 Feb 2016 09:51:18 GMT

And I wasn't sure why these expressions behave differently:

Mon, 15 Feb 2016 09:54:41 GMT

Particularly if I first sort on "Expression" Num#(PurgeChar(...)), Ascending but I also check the "Text" checkbox, what's the difference?