Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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.

m_woolf
Master II
Master II

Try adding double quotes:

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