topic Re: Linking tables without association in QlikView

Linking tables without association

Anonymous — Thu, 11 Oct 2018 09:14:41 GMT

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.

Re: Linking tables without association

swuehl — Thu, 11 Oct 2018 09:23:40 GMT

Please post your question only once, it makes it hard to follow a discussion and clutters the forum.

Linking tables without association

Re: Linking tables without association

Anonymous — Thu, 11 Oct 2018 10:17:42 GMT

Sorry about that. I actually thought I only posted it once as the page froze the first time I tried. So I reposted and took another group while I was at it.

Seems it went through the first time anyways.

Sorry for the inconvenience and thanks again for the help.

Danny