Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

Another Concat Order Issue

BatchIDAge
AB1234Z4645
AB1234Q7632
AB1234B9861
BB5678Q3457
BB5678G1134
BB5678A3458

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

ID

B98,Q76,Z46

Age

32,45,61

I need it to concat as this

ID

Z46,Q76,B98

Age

45,32,61

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

any help please

1 Solution

Accepted Solutions
spikenaylor1
Creator
Creator
Author

Great that worked

View solution in original post

4 Replies
tresesco
MVP
MVP

Try using the third parameter like:

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


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

spikenaylor1
Creator
Creator
Author

Great that worked

ogautier62
Specialist II
Specialist II

Hi

it works for me with physical order like this :

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

regards

tresesco
MVP
MVP

Great!  Please mark the correct reply as 'Correct'