Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hopkinsc
Valued Contributor II

How to pass a selection to another field

Hi,

I am trying to set up a trigger to pass a selection from [Operative Region] and put it onto [Order Region] so the outcome would be i would have the same selection in both fields.

The fields are not linked which is why i wanted to do it this way.

Thanks

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: How to pass a selection to another field

replace the search string with exactly this :

='=sum({<F2=F1>} 1)'

6 Replies
Not applicable

Re: How to pass a selection to another field

Hi hopkinsc,

     If [Operative Region] and [Order Region] have the same values in some cases you can use a set analisys expresion using = operator like that [Order Region] = {$([Operative Region])}

I hope to help you.

MVP
MVP

Re: How to pass a selection to another field

Hi,

Check attached document for solution.  To do this you need to add trigger for the field, I added the trigger for field by doing the following steps.

Document Properties -> Triggers -> Field Event Triggers -> Select Field -> On Select Add Action -> Add -> Selection -> Select in Field

Hope this helps you.

Regards,

Jagan.

hopkinsc
Valued Contributor II

Re: How to pass a selection to another field

Hi This works, but it will only work if the data selected have no spaces in the text.

For example...

The fields contain region names..

East

West

Scotland

Outer London

Central London

North East

North West

etc

the East, West and Scotland work, but it won't pass any details across for the others.

Does anyone one how to overcome this?

Thanks

giakoum
Honored Contributor II

Re: How to pass a selection to another field

replace the search string with exactly this :

='=sum({<F2=F1>} 1)'

MVP
MVP

Re: How to pass a selection to another field

It works.  Check attached file.

Regards,

Jagan.

giakoum
Honored Contributor II

Re: How to pass a selection to another field

dont ask why it works...

Community Browser