topic Re: Selection in one field, selects automatically another selection in another field in QlikView

Selection in one field, selects automatically another selection in another field

Wed, 20 Jul 2016 09:18:20 GMT

I have two fields which have two options each. I want that a certain selection in the first field, will select automatically a specific selection in the other field.

For example:

Field 1 options: 'To Keep / To Drop

Field 2 options: Orders / Returns

If the user presses 'To Keep' , field 2 gets 'Orders' and if the user presses 'To Drop' , field 2 gets 'Returns'

Thank you very much,

Gili

Re: Selection in one field, selects automatically another selection in another field

Anonymous — Wed, 20 Jul 2016 10:02:12 GMT

Hi,

Can you share your qvw file, so we can suggest a solution ?

Thx

Re: Selection in one field, selects automatically another selection in another field

Wed, 20 Jul 2016 10:23:40 GMT

I'm sorry, I cant..

Is there anything you didnt understand? I'll explain again.

Thanks

Re: Selection in one field, selects automatically another selection in another field

Gysbert_Wassenaar — Wed, 20 Jul 2016 10:34:34 GMT

Open the Document Properties window, go to the Triggers tab. Then select your Field 1. Click on the Add Action(s) button under the OnSelect option. Add a Select in Field action. Use Field 2 for the Field setting and as Search string the expression: =If(Only([Field 1]) = 'To Keep', 'Orders', If(Only([Field 1])='To Drop', 'Returns')). Replace [Field 1] with the case sensitive field name of your real field 1.

Re: Selection in one field, selects automatically another selection in another field

Wed, 20 Jul 2016 10:48:34 GMT

Thank you so much!!