Discussion Board for collaboration related to QlikView Deployment.
Can anyone come up with an expression (no script solutions) to convert this list:
A, B C, D
This kinda works:
=chr(39) & replace(mytext',',', chr(39) & ',' & chr(39)) & chr(39)
Except it doesn't remove leading and trailing spaces from each element.
Go to Solution.
Not sure if this is the best solution, but I think we need a way to iterate over the substrings and apply a trim.
So I reused something I used for substring removal (posted here:http://community.qlik.com/message/162166)
Please find attached an adaption to your problem.
I tried and come up with this using valuelist function.
=Chr(39)&Concat(Trim(ValueList($(=chr(39) & replace('A, B, C, D',',', chr(39) & ',' & chr(39)) & chr(39)))), Chr(39) & ',' & Chr(39)) & Chr(39)