topic Re: Concatenate Values Within a Field in App Development

Concatenate Values Within a Field

Rehan — Wed, 26 Aug 2020 18:23:20 GMT

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 — Wed, 26 Aug 2020 18:56:56 GMT

Try this

Concat(FieldA, ',', Rank)

Rehan — Wed, 26 Aug 2020 19:32:38 GMT

Sorry my actual issue is that ranks is descending like

FieldA, Rank

This Product, 3

Avg Value,2

$80,1

bhavyagrb — Thu, 27 Aug 2020 05:08:38 GMT

Hi Rehan,

Try below expression:

concat(FieldA,' ',-Rank)

Regards,

Bhavya