Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner - Creator II
Partner - Creator II

select same value in other field

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?

1 Solution

Accepted Solutions
sunny_talwar

Try like this

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

View solution in original post

5 Replies
sunny_talwar

You can use Triggers to do this...

francisvandergr
Partner - Creator II
Partner - Creator II
Author

What trigger?

sunny_talwar

You have two options

1) Use OnAnySelect trigger

2) Field Event Triggers

Capture.PNG

francisvandergr
Partner - Creator II
Partner - Creator II
Author

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

sunny_talwar

Try like this

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