topic Sorting in a concatenation. in QlikView

Sorting in a concatenation.

boorgura — Thu, 14 Oct 2010 18:39:26 GMT

Hi Folks,

Is it possible to sort before concatenating a text field to show in a text box?

Now, it is getting concatenated in an alphabetical order.

Miguel_Angel_Baeyens — Thu, 14 Oct 2010 18:46:20 GMT

Hello Rocky,

You can do the following

Concat(Field, ',', DateField)

to sort by DateField or any other numeric sort field you have.

Hope that helps

boorgura — Thu, 14 Oct 2010 19:29:40 GMT

Hi Miguel,

Thanks for your response. But, I need to sort it in load order.

Is it possible?

Miguel_Angel_Baeyens — Thu, 14 Oct 2010 19:54:13 GMT

Hello,

Create a field in load time with

RowNo() AS LoadOrder

And use it with the Concat function above.