Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Selection Trigger, Issue with Strings containing Spaces

I am currently working on a file that requires listbox filtering using another listbox via triggers.

Occ is the controlling listbox and the listbox that needs to be modified is AllocValues.

     I works with singular values: Trigger, Select in Field, =Occ

     I works with multiple values that do not contain spaces:   Trigger, Select in Field, ='(' &Replace(GetFieldSelections(Occ),',','|') & ')'

but the issue is that any values within Occ that have a space do not make it over to the receiving listbox.


I tried ='("' &Replace(GetFieldSelections(Occ),',','"|"') & '")' to wrap each entry with "" but that didn't work as well.

Anyone have guidance for this issue? Can I do a replace or something to make the items that contain spaces get picked up?

Thanks in advance

1 Reply
swuehl
MVP
MVP

Using double quotes should work.

Your replace method introduces an additional space for all values but the the first, which seems not to bother QV when using values without a space, but containing a space.

This should correct for that:

='("' &Replace(GetFieldSelections(Occ),', ','"|"') & '")'

Check also attached.