Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vvvvvvizard
Contributor III

Link budget with actual

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

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: Link budget with actual

Yes, the logic is correct

7 Replies
YoussefBelloum
Esteemed Contributor

Re: Link budget with actual

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.

vvvvvvizard
Contributor III

Re: Link budget with actual

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

YoussefBelloum
Esteemed Contributor

Re: Link budget with actual

Month 3 is Periode 1 ? how ?

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

vvvvvvizard
Contributor III

Re: Link budget with actual

I guess il show it as a forecast then

YoussefBelloum
Esteemed Contributor

Re: Link budget with actual

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

vvvvvvizard
Contributor III

Re: Link budget with actual

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

YoussefBelloum
Esteemed Contributor

Re: Link budget with actual

Yes, the logic is correct