Listbox Sorting Alphanumerical - Word1,Word10,Word2

[retko1985]

Hello,

I have problem getting the right sort for alphanumeric data, so I have like this:

Word1

Word10

Word11

...

Word2

How can i try to solve it?

Thank you.

[Saravanan_Desingh]

Let us assume your FieldName is Field. Before the actual data load from file, please load a dummy values which are expected expected.

tab1:
LOAD 'Word'&RowNo() As Field
AutoGenerate 20;

In the ListBox->Sort, select 'Load Order'.

 

[Brett_Bleess]

The best thing would be a sample application/QVW file, so folks can see directly what you have setup, little difficult to determine exactly where the problem lies otherwise.  Saran's idea could potentially work if you perform the steps in the load script to Order by when loading:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

I believe what you are currently seeing is working as expected though from what I recall.  Cannot find anything further in the Help other than it is per the ASCII rules.  

http://support.ecisolutions.com/doc-ddms/help/reportsmenu/ascii_sort_order_chart.htm

Sorry I do not have anything better for you.

Regards,
Brett

[martinpohl]

here's an example:

load
dual(Word,Wordnum) as Word;

load Word,
keepchar(Word,0123456789) as Wordnum
;

LOAD * INLINE [
Word
Line1
Line2
Line11
];

keep only numbers in second field, make field to dual field so you can see alphanumeric but sort by numeric

Regards