Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Text Sort Mode

I have try to test qlikview sort by text as below. Qlikview do not sort by ascii mode. Could someone tell me how QV sort?

0Z
15
15MZZZZZ
15N
15NZZZZZ
1213sdad
05000
1234566
dfdfs885
dsd445
dsds458
efdfd
sdasd4565
yytyty555
4 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi,

Please check out this post.

thanks,

Rajesh Vaswani

Not applicable
Author

Please give me a link.

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Here is the link.

     http://community.qlik.com/thread/12794

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

It could be alphabetical. http://www.textfixer.com/tools/alphabetical-order.php

From Chart Property help

Text     Dimension values will be sorted according to their alphabetical order.

But from the help of load script help.

Order by is a clause used for sorting the records of a resident table before they are processed by the load statement. The resident table can be sorted by one or more fields in ascending or descending order. The sorting is made primarily by numeric value and secondarily by national ASCII value. This clause may only be used when the data source is a resident table. The ordering fields specify which fields the resident table is sorted by. The field can be specified by its name or by its number in the resident table (the first field is number 1).

I have try on load script but It is not sort by ASCII. Should it be a bug?