Auto Select Fields

[Anonymous]

Hello,

I want to know if there is a way to do the following on qlikview:

I have 2 tables, for example:

Table1: (1,2,3,4,5)

Table2: (a,b,c,d,e,f)

These two tables have nothing in common on the model.

What I want to know is that if you can, for example, select the field "1" on Table1 and automaticly qlikview selects the letter "b" from table 2.

I don't mean that qlikview shows me the letter "a" from the table, i want to get two different selections:

Selection N°1: 1

Selection N°2: a

Thank you very much

[sunny_talwar]

Have you looked into the possibility of using triggers?

Best,

Sunny

[MarcoWedel]

Hi,

maybe you could just link the two tables, creating a link table like

tabLink:
LOAD * Inline [
table1field, table2field
1,a
2,b
3,c
4,d
5,e
];

hope this helps

regards

Marco

[maxgro · Accepted solution]

Field Code is 1,2,3,4,5

add a select in field trigger for field Code

with this search string

=if(GetSelectedCount(Code)>0

  ,'("' & concat(DISTINCT pick(match(Code, 1,2,3,4,5),'a','b','c','d','e'), '"|"') & '")'

  ,''

)

don't like it but it works

[Anonymous]

Thanks a lot!