Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
retko1985
Creator II
Creator II

Listbox Sorting Alphanumerical - Word1,Word10,Word2

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.

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

commQV31.PNG 

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
martinpohl
Partner
Partner

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