topic Re: Another Concat Order Issue in QlikView

Another Concat Order Issue

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

I am using the concat in an expression in a straight table along with other expressions to give me my table view of all required data.

Concat(ID,',')

Concat(Age,',')

it concats as this

For Batch AB1234

B98,Q76,Z46

Age

32,45,61

I need it to concat as this

Z46,Q76,B98

Age

45,32,61

I need them to not sort at all, just concat in the original order

any help please

tresB — Thu, 05 Jul 2018 10:04:31 GMT

Try using the third parameter like:

Concat(Age,',', Aggr(RowNo(), Age))

Concat(ID,',', Aggr(RowNo(), ID))

spikenaylor1 — Thu, 05 Jul 2018 10:19:38 GMT

Great that worked

ogautier62 — Thu, 05 Jul 2018 10:21:00 GMT

it works for me with physical order like this :

concat(ID,',',num(FieldIndex('ID',ID)))

regards

tresB — Thu, 05 Jul 2018 10:21:34 GMT

Great! Please mark the correct reply as 'Correct'