Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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