Discussion Board for collaboration related to QlikView App Development.
I have synchronized data through triggers in the document properties so that selecting one or more values in a field are also selected on the other.
Everything works perfectly except when the field content is a compound word (in the example Puerto Rico)
The FUNCTION I am using for synchronization is
= '(' & Getfieldselections (country, '|') & ')'
How could you solve it?
Hi,
Use it as below. It should work.
= '(' & Replace(getfieldselections(A.NombrePais,'|'),' ','*') & ')'
Issue is with Space
Thanks,
hemanth.
Hi,
Use it as below. It should work.
= '(' & Replace(getfieldselections(A.NombrePais,'|'),' ','*') & ')'
Issue is with Space
Thanks,
hemanth.
Try adding double quotes:
= '("' & getfieldselections(A.NombrePais, '"|"') & '")'