Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ariel_klien
Valued Contributor

Sort Alpha Numbers

Hello all Experts,

I have filed with codes that include numeric and alpha .

How can I sort them in a chart like this:

01

02

03

..

..

18

19

1A

1B

1C

20

21

23

..

..

29

2A

2B

And so on....

I attached a file with the codes

Thanks,

Ariel

1 Solution

Accepted Solutions

Re: Sort Alpha Numbers

Hi,

Try this code.

Directory;

LOAD Code,

  Ord(Left(Code,1)) + (Ord(Right(Code,1))/100) as Sort

FROM

Codes.xlsx

(ooxml, embedded labels, table is Sheet1);

Use Sort Fields in sorting tab of property and use expression sort functionality.

Regards,

Kaushik Solanki

View solution in original post

4 Replies
nagireddy_qv
Contributor II

Re: Sort Alpha Numbers

Hi

Please find the attached sample file..

ariel_klien
Valued Contributor

Re: Sort Alpha Numbers

Hi

Thanks for the quick answer.

But as you can see in the example. this is not what i need.

i need that code '1A' will be after code '19' and not after code '99'

Ariel

Re: Sort Alpha Numbers

Hi,

Try this code.

Directory;

LOAD Code,

  Ord(Left(Code,1)) + (Ord(Right(Code,1))/100) as Sort

FROM

Codes.xlsx

(ooxml, embedded labels, table is Sheet1);

Use Sort Fields in sorting tab of property and use expression sort functionality.

Regards,

Kaushik Solanki

View solution in original post

ariel_klien
Valued Contributor

Re: Sort Alpha Numbers

Works.

Thanks.