Discussion Board for collaboration on QlikView Scripting.
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.
Just a sanity check , if one table joins another table using a composite key the model will work , straightfoward .
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