topic Re: Problem with selection triggers in QlikView

Problem with selection triggers

Anonymous — Mon, 27 Apr 2015 14:30:49 GMT

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.

Re: Problem with selection triggers

rajkumarb — Mon, 27 Apr 2015 14:39:32 GMT

Try Using this

In Document Properties -> Field Event Trigger

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

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

HTH

Re: Problem with selection triggers

Anonymous — Mon, 27 Apr 2015 14:56:56 GMT

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

Re: Problem with selection triggers

rajkumarb — Mon, 27 Apr 2015 15:12:53 GMT

Please Check this App

I misunderstood for Table as field

HTH