Problem with selection triggers

[Anonymous]

hello dear QlikView Community:

First of all I want to appreciate your help with the problems that I've had in the past developping with qlikview.

Now I have another problem, this one related to the use of triggers.

I have two Tables:

TableA:               TableB:

1                         1

2                         2

3                         3

This is the trigger that I'm using:

=if(GetSelectedCount(TableA)>0

  ,'("' & concat(DISTINCT pick(match(TableA,1,2,3), 1,2,3), '"|"') & '")'

  ,''

)

The problem that I'm Having is that when I select a value from table A, it Selects the same value in Table B (which is correct), but, it deselects the first Value, and I don't want that to happen.

Is there a way to solve this?

Thank you very much.

[rajkumarb]

HI

Try Using this

In Document Properties -> Field Event Trigger

FieldA-> Add Action -> Select In Field -> Field = FieldB,

Search String = ='=Only({<FieldB=$::FieldA>}FieldB)'

HTH

[Anonymous]

I realized that the example is not quite good,

Take in consideration that I have the following tables:

Table A:          Table B:                   

3                         3

15                        15

40                         40

50                         50

54                         54

55                         55

60                         60

65                         65

999                        999

Would it work for these tables?

The code that you posted: "   ='=Only({<FieldB=$::FieldA>}FieldB)'   " didn't work

Thank you

[rajkumarb]

HI

Please Check this App

I misunderstood for Table as field 

HTH