Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 & '"', '|') & ')')