topic Re: Data Synchro in QlikView

Data Synchro

ecolomer — Tue, 12 Jan 2016 15:17:14 GMT

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?

hemhund2016 — Tue, 12 Jan 2016 15:29:07 GMT

Hi,

Use it as below. It should work.

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

Issue is with Space

Thanks,

hemanth.

m_woolf — Tue, 12 Jan 2016 15:36:30 GMT

Try adding double quotes:

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