topic Re: Alphabetical Sorting in Listbox in QlikView

Alphabetical Sorting in Listbox

Fri, 22 Nov 2013 12:59:37 GMT

Hello,

We have implemented a listbox containing a numeric dimension, string and mixed expressions. We would like to sort all of these dimension and expressions seperately based on variables. For example;

If variable=1 sort based on dimension

if variable=2 sort based on expression1

if variable=3 sort based on expression2...

We accomplished all of these however we applied sorting on string and mixed expressions only for the first character. What we want is a proper ordering for all of the characters.

Example: 1230adf

13k

10b

alk

ayk

bab

bzg

bbk

What we would like to do is:

10b

1230adf

13k

alk

ayk

bab

bbk

bzg

The reason of the sort problem is caused by using "ord" function which is only concerned with the first character of the string. But we have to find a solution for sorting through all the characters. Is anyone ever had this problem before or could you help us with solving the problem and suggest another sort function.

Regards,

Re: Alphabetical Sorting in Listbox

bbi_mba_76 — Fri, 22 Nov 2013 14:56:14 GMT

Hi,

maybe it is better define the sort order in the script, and then use an expression to choose the criteria.

Field, Sort1, Sort2, Sort3

13k	1	2	3
alk	2	3	4
ayk	3	4	5
bbk	4	5	6
bzg	5	6	7
bab	6	7	8
10b	7	8	9
ac	8	9	1
1230adf	9	1	2

Re: Alphabetical Sorting in Listbox

Fri, 22 Nov 2013 15:07:08 GMT

This is only for a limited number of records whereas we need a generic solution since we are dealing with a huge amount of data.

Re: Alphabetical Sorting in Listbox

bbi_mba_76 — Fri, 22 Nov 2013 15:31:10 GMT

Well, in my cases espressions to sort are not working so fine, so I prefer set the sort in the script.

I found a discussion, but it is quite complicated...

Re. :Re: Sorting column in ASCII mode

Re: Alphabetical Sorting in Listbox

Ken_Thomas — Wed, 29 May 2019 17:39:18 GMT

I know this is an older post, but I updated an article which attempts to explain the algorithm for sorting of alphanumeric data in Qlik: https://support.qlik.com/articles/000005509

-Ken