Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner
Partner

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
Partner
Author

What trigger?

sunny_talwar

You have two options

1) Use OnAnySelect trigger

2) Field Event Triggers

Capture.PNG

francisvandergr
Partner
Partner
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 & '"', '|') & ')')

View solution in original post