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: 
b_garside
Partner - Specialist
Partner - Specialist

Concat with Line Feed ?

Hi I need to use Concat to show the values of a field using GetFieldSelections().

Im sure its a syntax issue with Chr(10). I need the values to go to the next line due to space constraints.

Concat(GetFieldSelections(ContractNumber),Chr(10) )



1 Solution

Accepted Solutions
Not applicable

Try using a line break as shown, but with ContractNumber instead of Date:

Example.JPG.jpg

View solution in original post

7 Replies
Gysbert_Wassenaar

Try Concat(ContractNumber,Chr(10))



talk is cheap, supply exceeds demand
Not applicable

Try using a line break as shown, but with ContractNumber instead of Date:

Example.JPG.jpg

b_garside
Partner - Specialist
Partner - Specialist
Author

This works but list all the values rather just the few.

Gysbert_Wassenaar

It will list all the possible values of the field. Those would be the same values that getfieldselections would return if any values were selected in that field.


talk is cheap, supply exceeds demand
Not applicable

You would need a DISTINCT.  Concat(DISTINCT ContractNumber,Chr(10))

Gysbert_Wassenaar

Ah, of course. Good point.


talk is cheap, supply exceeds demand
b_garside
Partner - Specialist
Partner - Specialist
Author

This seemed to do the trick. Nice workaround.