select the associated values in the other list box automatically?

[Anonymous]

Hi Experts,

If I select a value in a list box, Automatically it has to select associated values in different list box how?

[its_anandrjs]

Use field event triggers for this.

[Anonymous]

HI Ananda,

Thanks for your reply,

I have tried using field event triggers but, not working.The other list box is showing the possible values

in white and remaining in grey colour.

Thanks

swathi

[YoussefBelloum]

Try with the Triggers,

find attached

[Anonymous]

Hi Anand,

I am using QV Personal edition. If you dont mind, can you pls share the steps.

Thanks for your efforts.

[YoussefBelloum]

Suppose you have 2 fields (Field1 and Field2) on your table, you want to automatically select the value of the Field2 when you make selection on Field1:

to do this:

1     create a variable:  vTest

=FieldIndex( 'Field11', Only(Field1) )

to understand fieldIndex function: FieldIndex - script and chart function ‒ QlikView

2.     Create the Trigger:

[surendraj · Accepted solution]

use aggr(fieldname,filedname)