Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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, '"|"')  & '")'