Discussion Board for collaboration on QlikView Scripting.
The budget table showing incorrect data.
The correct data are as right table (Budget 2).
In addition, the budget should show the same data for all years - 2007, 2008, 2009, 2010.
"Budget" table comes from the budget tab in the edit script
"Budget2" table comes from the budget2 tab in the edit script.
I'd suggest you outer join your monthly budget table to a table of years. Have a look at the sample script at the bottom of this reply.
[It would be a better data model it then you converted the Month & Year into a QV date field for MonthYear and then suitably join this onto your Date table]
LOAD * INLINE [
Outer Join (Budget)
monthname(date#(Year & BudgetMonth, 'YYYYMMM')) as MonthYear ,
Best Regards, Bill
Thanks for your response, but it does not work.
Maybe I need to change something in the date sheet or sales?
Anyway, what about the first part of my question?
Your Budget-2 table is not linked to data model so you are not getting the right data. Please try to connect the Budget-2 data with data model.