select same value in other field

[francisvandergr]

I have two fields in Qlikview with the same values.

Values:

Field1                           Field2

A                                    A                              

B                                   B

C                                  C

D                                  D

When i select in field 1 value B    i like to have field 2 value B also selected.

And when i change a value in Field 1 also field2 must change with same value.

Is this possible and how?

[sunny_talwar]

You can use Triggers to do this...

[francisvandergr]

What trigger?

[sunny_talwar]

You have two options

1) Use OnAnySelect trigger

2) Field Event Triggers

[francisvandergr]

Arikel.Code must change with value of field Component . What is my Search string ?

[sunny_talwar · Accepted solution]

Try like this

=If(GetSelectedCount(Field2) >0, '(' & Concat(DISTINCT '"' & Field2 & '"', '|') & ')')