Simple list box sort

[#1]

Hello all,

I can't believe I am struggling with this! I have a set of values that I want to display in a list box:

0000CARRIAGE

001ISLEOFMAN

02NMX20147-2

02NMX20147-4

03-20-009/23

0011A1000065

0065B1006175

0070A1004358

0073A9920262

440KEY05HGHB

700KEY080TNT

0900FU0569FO

000000001391

9820-0004/13

000000016209

099742-10700

I want them to be displayed in the sequence (as per Excel sort ascending):

000000001391

000000016209

0000CARRIAGE

0011A1000065

001ISLEOFMAN

0065B1006175

0070A1004358

0073A9920262

02NMX20147-2

02NMX20147-4

03-20-009/23

0900FU0569FO

099742-10700

440KEY05HGHB

700KEY080TNT

9820-0004/13

I load the data using

Load text(Field1) as TextField...

I would expect a simple sort on State and Text on the listbox properties would do it but...!!!

Thanks!

Gordon

[perumal_41]

Please Check Is correct or not

[ToniKautto]

Setting sort order to Text = A>Z should to the trick. Do you have any other sorting enabled at the same time?

If you still have this problem, please attach a sample QVW, so that your settings can be evaluated.

[#4]

Guys,

The list box properties are nothing more than state & Text A>Z.

This is very weird.

I have attached a xls with the data and a simple qvw.

I am using V9SR4 - how about you?

Regards,

Gordon

[ToniKautto]

This looks like a bug to me, and I can also reproduce it on QV10 SR2.

Please report it to QlikView support for further evaluation.

support@qlik.com or http://qlik.com/Support

[#6]

I have now reported it to support and will post the response.

Regards,

Gordon

[montubhardwaj]

Ok. You can have the values sorted in excel( as you said, you want them to be sorted as per excel) and then load into QV. Then you can sort it based on Load Order=> Origional.

[#8]

The data is actually just an example subset of a .csv file that is regularily FTPd and contains 26k rows, so that is not an option unfortunately.

Regards,

Gordon

[nathanfurby]

Hey Gordon - I've seen this happen with List Boxes before.  Doesn't seem to be any reason why it doesn't sort.

I think the attached example could be a work around - using a Text() expression rather than the field itself.

[#10]

Thanks Nathan,

Very odd behaviour isnt it - a good workaround in the meantime though.

Regards,

Gordon