topic Re: associating fields in QlikView

associating fields

Anonymous — Tue, 15 Sep 2015 08:19:15 GMT

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.

Re: associating fields

jonathandienst — Tue, 15 Sep 2015 08:24:01 GMT

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?

Re: associating fields

datanibbler — Tue, 15 Sep 2015 08:24:50 GMT

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

Re: associating fields

qlikmsg4u — Tue, 15 Sep 2015 08:27:13 GMT

find the attached app,

Re: associating fields

Gysbert_Wassenaar — Tue, 15 Sep 2015 08:27:47 GMT

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.

Re: associating fields

Tue, 15 Sep 2015 08:40:48 GMT

Hi,

You can find a solution in the app.

Re: associating fields

Anonymous — Tue, 15 Sep 2015 12:20:22 GMT

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.