topic Re: How to get associate field value into a variable of selection field from the listbox ? in QlikView

How to get associate field value into a variable of selection field from the listbox ?

charles1981 — Thu, 13 Jun 2019 12:20:34 GMT

Hi,

Anyone help me to achieve this please? I have one table like below:

Parent	Child
Car	ABC
Car	DDS
Truck	west
Truck	Ouija

from this I loaded Child field into a List box for selection. so When I select any child from the list box, I want to assign the associated parent value into a variable. for example, if I select a child "DDS" then I want that parent value "Car" into a variable or if selected "Ouija" then "Truck" into a variable.

Re: How to get associate field value into a variable of selection field from the listbox ?

sunny_talwar — Thu, 13 Jun 2019 12:28:56 GMT

Have you looked into Field Event Triggers?? Triggers

Re: How to get associate field value into a variable of selection field from the listbox ?

charles1981 — Fri, 21 Jun 2019 13:59:13 GMT

Hi Sunny T,

Thanks for your suggestions.

I tried using triggers as you suggested but I couldn't able to achieve my requirement.

I have attached the .qvw files. could you please check and guide me where I did wrong?

I want the parent of selected child to be assigned to the variable varModelParent.

Re: How to get associate field value into a variable of selection field from the listbox ?

charles1981 — Mon, 24 Jun 2019 10:29:10 GMT

Done using Field event Triggers as suggested by Sunnt T. Thank you so much.