topic Re: How to pass a selection to another field in QlikView

How to pass a selection to another field

hopkinsc — Tue, 25 Sep 2012 10:52:07 GMT

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

Re: How to pass a selection to another field

Tue, 25 Sep 2012 11:13:29 GMT

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.

Re: How to pass a selection to another field

jagan — Tue, 25 Sep 2012 11:22:30 GMT

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.

Re: How to pass a selection to another field

hopkinsc — Wed, 26 Sep 2012 12:06:33 GMT

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

Re: How to pass a selection to another field

giakoum — Wed, 26 Sep 2012 12:16:46 GMT

replace the search string with exactly this :

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

Re: How to pass a selection to another field

jagan — Wed, 26 Sep 2012 12:23:32 GMT

It works. Check attached file.

Regards,

Jagan.

Re: How to pass a selection to another field

giakoum — Wed, 26 Sep 2012 12:25:34 GMT

dont ask why it works...