Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Rehan
Creator III
Creator III

Concatenate Values Within a Field

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?

1 Solution

Accepted Solutions
bhavyagrb
Partner
Partner

Hi Rehan,

Try below expression:

concat(FieldA,' ',-Rank)

Regards,

Bhavya

View solution in original post

3 Replies
sunny_talwar

Try this

Concat(FieldA, ',', Rank)
Rehan
Creator III
Creator III
Author

Sorry my actual issue is that ranks is descending like

FieldA, Rank

This Product, 3

Avg Value,2

$80,1

bhavyagrb
Partner
Partner

Hi Rehan,

Try below expression:

concat(FieldA,' ',-Rank)

Regards,

Bhavya

View solution in original post