Concatenate Values Within a Field

[Rehan]

I am using Qlik Sense Server April 2020 Release. I have a field with bunch of values I would like to concatenate For Example

FieldA, Rank

This Product, 1

Avg Value,2

$80,3

WHen I use Concat(FieldA,',') in script I get 

"Avg Value, This Product,$80"

What I would like to see is 

"This Product Avg Value $80"

How I can accomplish this?

[sunny_talwar]

Try this

Concat(FieldA, ',', Rank)

[Rehan]

Sorry my actual issue is that ranks is descending like

FieldA, Rank

This Product, 3

Avg Value,2

$80,1

[bhavyagrb · Accepted solution]

Hi Rehan,

Try below expression:

concat(FieldA,' ',-Rank)

Regards,

Bhavya