Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Currently i have below data set:
=============================================
this "Month " in the above table is created from the below script:-
Table_Budget:
Load Budget,
'Budget' a s flag
From .....
join
load * inline[
Month
Jan,
Feb,
Mar,
Apr,
May,
...
Dec
];
Final
Load *,
Num(Budget)/12 as New_budget
Resident Table_Budget;
Drop table Table_budget
Store * into Budget.qvd
===============================================================
Data:
Load
Object_no,
Flag, //Flag for Actual
Date
From ...[Actual.qvd](qvd);
Concatenate
Load
Object_no,
Flag, //For Budget
"Month"
From ..[Budget.qvd](qvd);
======================================================
I have linked my "Master Calendar" with the "Date" feild.
However i am not able to understand , how should i link my "Month" field from "Budget.Qvd" to Master calendar as i want to display the months in fiscal year pattern and i have created inline starting from Jan to Dec.
Please help !
Change the inline load of the month with something like this:
Load MakeDate(2020,RecNo(),1) as Month
Autogenerate 12;
And while concatenating, use the Month as Date in the fact, It should link to the Calendar then
Just use a real date instead of a month. Means instead of using: Jan, Feb, ... you takes 01.01.2020, 01.02.2020, ...
- Marcus
Change the inline load of the month with something like this:
Load MakeDate(2020,RecNo(),1) as Month
Autogenerate 12;
And while concatenating, use the Month as Date in the fact, It should link to the Calendar then