topic Re: Link budget with actual in QlikView

Link budget with actual

vvvvvvizard — Thu, 18 Jan 2018 12:47:04 GMT

Struggling with these two tables , should i create another link table or is their a way to concatenate them

Re: Link budget with actual

YoussefBelloum — Thu, 18 Jan 2018 13:07:08 GMT

Hi,

on the Budget table, the Period field is the Month field ?

here the problem is that you have a Budget for year 2013 and the transactions are for 2011 and 2012..

you can link them by creating a composite key, but you can't compare your sales with your Budget.

Re: Link budget with actual

vvvvvvizard — Thu, 18 Jan 2018 13:14:35 GMT

Budget is in financial year, month 3 is period 1, transactions is in calendar date

Re: Link budget with actual

YoussefBelloum — Thu, 18 Jan 2018 13:17:25 GMT

Month 3 is Periode 1 ? how ?

can you take a look at what I wrote to you and elaborate more ?

Re: Link budget with actual

vvvvvvizard — Thu, 18 Jan 2018 13:48:31 GMT

I guess il show it as a forecast then

Re: Link budget with actual

YoussefBelloum — Thu, 18 Jan 2018 13:53:26 GMT

it depends on how it was calculated.. both are estimations.

your key here is the COMPANY_ID and CUSTOMER_ID, so you should use a composite key

Re: Link budget with actual

vvvvvvizard — Fri, 19 Jan 2018 06:29:42 GMT

Scenario 1

Just a sanity check , if one table joins another table using a composite key the model will work , straightfoward .

scenario

If 3 or more tables are joined by the same composite key , then one has to use a link table or concatenate the tables where applicable . Is that logic correct

Re: Link budget with actual

YoussefBelloum — Fri, 19 Jan 2018 08:45:18 GMT

Yes, the logic is correct