Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have an issue with the sort order of a list box. In a basic example i have a 5 character code the Text sort option is ticked and A-Z selected but the result is not what i would expect. The codes are N02AS. N02D1, N2BCP & N2CTC (note the 2nd character of the first two codes is a Zero)
Qlikview lists them:-
N02AS
N2BCP
N2CTC
N02D1
Which is not the correct alphabetic order, it would appear that the a zero has been added to the middle to codes to produce the order, which is incorrect.
I can get round this be using a sort Expressions of:-
=(((((ord(mid(LC,1,1))*256)+ord(mid(LC,2,1)))*256+ord(mid(LC,3,1)))*256+ord(mid(LC,4,1)))*256+ord(mid(LC,5,1)))*256
But my question is WHY! and does anyone know of a simpler fix?
Sample fileattached ifyou wantto havea play.....
Hi Andrew,
it will probably not help you, but you are not alone: community.qlik.com/message/12794
I agree that QlikView should keep an eye on the sorting issues, there are several threads complaining about sorting (mostly when using e.g. pivot tables, so not all about yours).
Interestingly, I just played around with your sample and I now get this sort:
N2BCP |
N2CTC |
N02D1 |
N03A |
If enabling only text A->Z sort. Not sure why, but definitely not correct.
Stefan
Andrew
I added an article on my blog about creating custom sort orders using dual values and it might be useful to you.
http://yahqblog.blogspot.com/2011/10/dual-values-for-self-sorting_16.html
Regards
Jonathan
Will qlikview have an update for this? Seems pretty complex to customize and / or sort a listbox.
Hi
We can sort the fields using as we want in the script.
You just check the attached qv file and listbox sorting table..
Regards
Ashok