topic Re: Auto Select Fields in QlikView

Auto Select Fields

Anonymous — Fri, 24 Apr 2015 19:41:19 GMT

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 — Fri, 24 Apr 2015 19:55:16 GMT

Have you looked into the possibility of using triggers?

Best,

Sunny

MarcoWedel — Fri, 24 Apr 2015 23:15:47 GMT

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 — Sat, 25 Apr 2015 15:00:25 GMT

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 — Mon, 27 Apr 2015 13:26:56 GMT

Thanks a lot!