Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
By the way, I say I "expect" Text(Line) to sort like this:
1a
1b
2
3
4
5
6
7
8
9
10
11
12
13a
13b
But if it were lexicographic sorting, wouldn't it be:
10
11
12
13a
13b
1a
1b
2
3
4
5
6
7
8
9
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"]
And I wasn't sure why these expressions behave differently:
Particularly if I first sort on "Expression" Num#(PurgeChar(...)), Ascending but I also check the "Text" checkbox, what's the difference?