topic Re: Alpha Numeric sorting in QlikView

Alpha Numeric sorting

brindlogcool — Wed, 16 Oct 2013 20:50:44 GMT

Hi,

I have a concatenated column of customer code and customername and trying to sort it. It is not working fine.

The column values are like this

Customer_code

001(SSSS)

003(AAAA)

004(PPPP)

I tried to sort through load script, Expression but either of this is working. it is always sorting by numerical values.

If try with Text and Numerical Value in the sort but it takes the numbers as the precedence.

Re: Alpha Numeric sorting

rustyfishbones — Wed, 16 Oct 2013 21:00:10 GMT

How many value do you have?

What way do you need it sorted?, above you have it sorted by Customer Code, I assume all customer Codes and Customer Names are unique.

So you will always have numbers and text so therefore you need to decide by which you want to sort

Re: Alpha Numeric sorting

rustyfishbones — Wed, 16 Oct 2013 21:03:55 GMT

Did you try concatenating the Customer Code and Customer Name the other way round

customername& '-' &customercode

and then try sort

Re: Alpha Numeric sorting

Wed, 16 Oct 2013 21:06:18 GMT

You can bring the concatenated column and the column with only the code and place the order by the command code column.

The object you sort by load order.

Re: Re: Alpha Numeric sorting

brindlogcool — Thu, 17 Oct 2013 14:06:01 GMT

I tried all the above options but it is still taking the number as the precedence.

@Alan - it is dynamic and keep changing.So we cannot say it as predefined numbers

Re: Alpha Numeric sorting

Thu, 17 Oct 2013 14:27:42 GMT

I think one option may be generating an ordenation field. First Load the table in codename order.

// This will create a table with secuential order number for each customername

Table_temp:

LOAD ......, Autonumber(customername) customername_order RESIDENT TABLE order by customername;

// This will create a table with a numeric field ordered by first customername and then customernumber.

Table_final:

LOAD *, customername_order & customernumber as order, RESIDENT Table_temp;

Expect that helped you.

Re: Alpha Numeric sorting

Ken_Thomas — Wed, 29 May 2019 17:41:13 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