Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
Try using a line break as shown, but with ContractNumber instead of Date:
This works but list all the values rather just the few.
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.
You would need a DISTINCT. Concat(DISTINCT ContractNumber,Chr(10))
Ah, of course. Good point.
This seemed to do the trick. Nice workaround.