Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ecolomer
Master II
Master II

Data Synchro

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?

1 Solution

Accepted Solutions
hemhund2016
Creator
Creator

Hi,

Use it as below. It should work.

= '(' & Replace(getfieldselections(A.NombrePais,'|'),' ','*') & ')'

Issue is with Space

Thanks,

hemanth.

View solution in original post

2 Replies
hemhund2016
Creator
Creator

Hi,

Use it as below. It should work.

= '(' & Replace(getfieldselections(A.NombrePais,'|'),' ','*') & ')'

Issue is with Space

Thanks,

hemanth.

View solution in original post

m_woolf
Master II
Master II

Try adding double quotes:

= '("' & getfieldselections(A.NombrePais, '"|"')  & '")'