Propagate field selection to other fields

[#1]

Hi all,

I've searched along the web and tried to follow similar threads, but I'm not achieving the target.

Please see attached image: whenever the user makes a selection on field "OV_R_CONFIGURAZIONE" is it possibile to propagate what he has selected on field "OA_R_CONFIGURAZIONE"? (so that propagation makes also "OrdiniAcquistoRiga" table to be filtered accordingly...). Same behaviour for viceversa.

I've tried to work with set analysis, but, as mentioned, didn't reach my goal...

I'm working on QlikView 10.

Thanks, regards.

--

Marco Pikiri

[swuehl]

There are some threads around the forum that demonstrate this, e.g.

Copy Selections from one field to another

[tracysmart · Accepted solution]

Hi Marco

you can set up a Field Event Trigger in Document Properties - Triggers.

you can add an 'onSelect' and 'onChange'

Action - Select in Field - Field: OA_R_CONFIGURAZIONE

SearchString: = '(' & getfieldselections(OV_R_CONFIGURAZIONE,'|') & ')'

[Gysbert_Wassenaar]

You can find an example here: Select in Field - Multiple Values Question. That's a one-way example. But to make it two-way you simply add the same kind of action to the field trigger of the mirror table.

[swuehl]

Another thread, with alternative approaches:

Passing ListBox selections to another (different) ListBox

[#6]

Thank you, Tracy, such event handling is exactly what I was searching for!

Thanks of course also to other people, I apologize for my bad searching on the web, I would have to find it by myself...

Regards.

--

Marco Pikiri