Help in creating Link table

Sun, 18 Nov 2012 20:30:03 GMT

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.

topic Help in creating Link table in QlikView