topic sort multi value field in QlikView

sort multi value field

kfoudhaily — Wed, 25 Jul 2018 12:06:43 GMT

I have a mutivalue fied

is there a way to sort in load script the values inside this field?

sunny_talwar — Wed, 25 Jul 2018 12:14:11 GMT

Sure, you can use Concat(..., ',', <SortingFieldHere>)

kfoudhaily — Wed, 25 Jul 2018 12:21:24 GMT

Thank you for your reply,

But I haven't concatenated my self the field, I got it that way from sorce

I need to unconcatenate it first to be able to use this expression.

regards,

sunny_talwar — Wed, 25 Jul 2018 12:36:03 GMT

In that case... may be do this in two steps

1) Use SubField to put them in different rows

2) Use Concat with sort to put them back in the same row