associating fields

[Anonymous]

Hi All,

I have 2 tables that are not linked using key field. However there is a field in both tables with similar values, however i dont want to link the table.

My requirement is, whenever user click on table1.ID, I want the association values in table2.Location field shown in TEXT OBJECT.

I am thinking to achieve this using 'Field Event Trigger'. But not sure how to achieve this. I created a field event trigger but its not working. Please assist.

[jonathandienst]

I don't understand what you are trying to do, but if you don't want QV's associative data model perhaps you should be doing this in Excel?

[datanibbler]

Hi Bharath,

if the fields are the same, you could use a trigger > select in field < - that is selected by default if you click on that use  menu.

Alternatively, you could join just that one column from table_B into table_A.

HTH

Best regards,

DataNibbler

[qlikmsg4u]

find the attached app,

[Gysbert_Wassenaar]

I don't see why you can't associate the fields by giving them the same name, but that's your problem. See attached qvw for setting up the field triggers.

[#6 · Accepted solution]

Hi,

You can find a solution in the app.

[Anonymous]

Thanks for all the replies.

To the question why i am doing this, our application is already in production and we don't want to change the data model now, so just want to write a expression in UI as a temporary fix.

I have build an expression by modifying the set analysis given by ! !augustin

I think this resolves the issue.

I am stilll wondering why people gave me 'Field event Trigger' for my requirement(as i fixed the issue without it. Sorry, for the basic question, as I am not good in triggers and it confuses me all the time.