topic Link Table or not too Link? in QlikView

Link Table or not too Link?

belgarathza — Mon, 09 Mar 2015 13:37:13 GMT

I'm battling with a situation whereby I'm not too sure if I should link a table or not. When I concatenate or join the tables then my figures are out and I cannot get to the correct profit. I tried to Link the table but I cannot get it to work. If there are any ideas it would be greatly appreciated. Attached are my test files.

Kind Regards.

Re: Link Table or not too Link?

puttemans — Mon, 09 Mar 2015 13:51:52 GMT

Hi Terence,

It's not entirely clear to me what tables you'd like to link, as your xlsx and qvd match.

Re: Link Table or not too Link?

belgarathza — Mon, 09 Mar 2015 20:32:19 GMT

Hi Johan

I want to create a link table that links all three tables together without any sync errors. I was thinking of creating a link table with the following fields: payroll, budget, period, fin_year and fin_month as standard fields which will link the three tables together.

Regards

Terence

Re: Link Table or not too Link?

puttemans — Tue, 10 Mar 2015 08:11:38 GMT

Hi Terrence,

Sorry, my bad. I did not see the other sheets in your data. I have created 2 separate keys that link into your biggest table. I think this way, you'll get the desired results. Can you check please?