topic Re: Listbox Sorting Alphanumerical - Word1,Word10,Word2 in QlikView

Listbox Sorting Alphanumerical - Word1,Word10,Word2

retko1985 — Thu, 30 Apr 2020 08:41:06 GMT

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.

Re: Listbox Sorting Alphanumerical - Word1,Word10,Word2

Saravanan_Desingh — Thu, 30 Apr 2020 16:29:21 GMT

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'.

Re: Listbox Sorting Alphanumerical - Word1,Word10,Word2

Brett_Bleess — Tue, 26 May 2020 12:34:04 GMT

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/ScriptRegularStatements/Load.htm

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

Re: Listbox Sorting Alphanumerical - Word1,Word10,Word2

martinpohl — Tue, 26 May 2020 13:10:37 GMT

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