[ ] needed in calculated dimension

[amien]

I have this calculated dimension:

=$(=(SubField(GetFieldSelections(_dim),',',1)))

It works very well, but the issue is that _dim cant contain a name like "Sales Order". So it can contain a fieldname which contains a space. It will result in a Calculation Error.  "SalesOrder" would work perfect with the above expression.

Question, where do i put the  [ ] to solve this? can't figure it out.

Thanks in advanced

[#2]

Try with this:

=$(=(replace(SubField(replace(GetFieldSelections(Quarter),' ','|'),',',1),'|',' ')))

[amien]

Thanks for your reply. But it's not working. Not sure also if we are on the same page.

I added an example

[MK_QSL · Accepted solution]

https://community.qlik.com/DOC-6046

[amien]

=$(=('[' & Trim(SubField(GetFieldSelections(_dim),',',1))) & ']')