Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

b_garside
Valued Contributor

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

Re: Concat with Line Feed ?

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

Example.JPG.jpg

7 Replies

Re: Concat with Line Feed ?

Try Concat(ContractNumber,Chr(10))



talk is cheap, supply exceeds demand
Not applicable

Re: Concat with Line Feed ?

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

Example.JPG.jpg

b_garside
Valued Contributor

Re: Concat with Line Feed ?

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

Re: Concat with Line Feed ?

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

Re: Concat with Line Feed ?

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

Re: Concat with Line Feed ?

Ah, of course. Good point.


talk is cheap, supply exceeds demand
b_garside
Valued Contributor

Re: Concat with Line Feed ?

This seemed to do the trick. Nice workaround.

Community Browser