topic Re: Propagate field selection to other fields in QlikView

Propagate field selection to other fields

Fri, 19 Jun 2015 14:59:32 GMT

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

Re: Propagate field selection to other fields

swuehl — Fri, 19 Jun 2015 15:03:22 GMT

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

Copy Selections from one field to another

Re: Propagate field selection to other fields

tracysmart — Fri, 19 Jun 2015 15:09:42 GMT

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,'|') & ')'

Re: Propagate field selection to other fields

Gysbert_Wassenaar — Fri, 19 Jun 2015 15:11:14 GMT

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.

Re: Propagate field selection to other fields

swuehl — Fri, 19 Jun 2015 15:11:50 GMT

Another thread, with alternative approaches:

Passing ListBox selections to another (different) ListBox

Re: Propagate field selection to other fields

Fri, 19 Jun 2015 15:40:25 GMT

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