topic Help with Sort on a List Box in QlikView

Help with Sort on a List Box

Fri, 19 Feb 2010 13:19:25 GMT

Hello !

Have had a hard time here trying to figure out what' wrong with my data.

It happens that I have an expression on a List Box Sort properties. And this Sort is not working as intended. That is, it's not sorting.

Please open the attached QVW. It's completely self-contained (inline data).

Take a look at the 'SEMESTER_DER_TEST' List Box. Notice how the 2008/2S (Second Semester of 2008) is WRONGLY bublying up on the List Box.

Can you figure out what's wrong ?

Help with Sort on a List Box

Fri, 19 Feb 2010 13:29:19 GMT

Hi Adriano

Not too sure why (probably the mixture of text/numbers in the field- i.e. the S) but the following expression does work:

=LEFT(SEMESTER_DER_TEST,4) & LEFT(RIGHT(SEMESTER_DER_TEST,2),1)

Note: it doesn't work too well without the = sign at the front.

Hope it helps,

Help with Sort on a List Box

Miguel_Angel_Baeyens — Fri, 19 Feb 2010 13:33:14 GMT

Hello Adriano,

I think that it should be enough ordering your field by "Text A -> Z" instead of using expressions, as the values, as they are, follow an alphabetical order. Give it a try and get back to us.

Edited:

You may use as well

=PURGECHAR(SEMESTER_DER_TEST, '/S')

deleting all characters that may distort your results (as they are not important in the sorting order)