Linking tables without association

[Anonymous]

Hi all,

I am trying to link two table together while on purpose not having them join/associate.

Let me explain based on example below. I have two table (Table 1 and Table 2). Both have a project column with the same values in them. So obviously, I could have both tables join/associate in Qlikview and link them up. I have a specific reason that I don't want to do that so in order to avoid this to happen, I qualified Table 2 in the loading script.

Now that that is done, I do would like the hours from Table 2 to appear in Table 1. I was thinking I can maybe do this by capturing the project letter of Table 1 and use that in a set analysis to sum the hours but not sure how to do that. I tried this expression in Table 1 but it is not working:

=sum({<Table2.Project = {'Project'}>} Table2.Hours)

Any ideas? Many thanks in advance.

[Anonymous]

Thanks Stefan and Emmanuel. It seems the best way to go is to join the table during the loading script. I'll give that a shot

Thanks again for the help