topic Re: Custom Sort Order by Varchar Column in QlikView

Custom Sort Order by Varchar Column

Mon, 09 Jun 2014 15:15:30 GMT

Hi All,

I have a data in a column with the below format .I need to sort by column.Can anyone help.

Column

1.1

1.1.1

1.1.2

1.1.2.7

1.1.2.8

1.1.2.9

1.1.3

1.1.3.3

1.1.3.4

1.1.3.8

1.1.3.9

1.1.3.10

alexandros17 — Mon, 09 Jun 2014 15:20:26 GMT

this is yet the natural sorting for the field, describe better your scenario

Mon, 09 Jun 2014 15:21:00 GMT

You can use subfields:

sort by this expression: Subfield(column,'.',3) which will return:

blank

Or sort by: Subfield(column,'.',4) to sort on your last "column"