Dear All.
I have two tables Invoice and CustomerBudgetForecast.
Invoice table contain TransactionDate and CustomerBudgetForecast table contain Period(YearMonth).
i want to create calender by considering both the dates.
invoice table contain Sales details and CustomerBudgetForecast table contain Budget and forecast.
i want to create a common month and Year fields for both the tables.
Invoice:
LOAD
CustomerCode,
PrimarySKU,
TransactionDate,
InvoiceHeader_New.PreSalesmanCode,
InvoiceHeader_New.PreSalesRouteCode,
Liter,
[Gross Sales Carton],
[Gross Sales Value],
[Gross Sales Litres],
[Returns Carton],
[Returns Value],
[Returns Liters],
[Discount Carton],
[Discount Value],
[Discount Liters]
FROM
D:\QLIKVIEW\QVDs\InvoiceHeader_New1.qvd
(qvd);
CustomerForecastBudget:
LOAD
CustomerCode,
RouteCode ,
DepotCode,
AlternateCode,
Period,
CFCVALUE,
CFCQTY,
CFCLTR,
CBUDVALUE,
CBUDQTY,
CBUDLTR
FROM
(ooxml, embedded labels, table is CustomerForecastBudget);
Thanks,
Mukram.