topic Re: Sort Alpha Numbers in QlikView

Sort Alpha Numbers

ariel_klien — Tue, 08 Mar 2016 08:48:50 GMT

Hello all Experts,

I have filed with codes that include numeric and alpha .

How can I sort them in a chart like this:

And so on....

I attached a file with the codes

Thanks,

Ariel

nagireddy_qv — Tue, 08 Mar 2016 08:53:49 GMT

Please find the attached sample file..

ariel_klien — Tue, 08 Mar 2016 08:57:30 GMT

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

kaushiknsolanki — Tue, 08 Mar 2016 09:00:12 GMT

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

ariel_klien — Tue, 08 Mar 2016 09:02:48 GMT

Works.

Thanks.