Common Date (Year, Month)

[naeemmohammed]

Hello,

Below is the, data loading script,  Data table and the result required. Please help me out with the actual script required the time of loading data.

InvoiceTable:

load *

from

D:\ABC\Invoice.qvd(qvd);

PurchaseTable:

load *

from

D:\ABC\Purchase.qvd(qvd);

[kfoudhaily]

can you provide sample data?

[neelamsaroha157 · Accepted solution]

this might be helpful -

Credit - rwunderlich‌

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

[vamsee]

Add the following script post your data load

LinkTable:


LOAD
StockCode,
Date(SalesInvoiceDate) as Date_Link
Resident InvoiceTable;
Concatenate
LOAD
StockCode,
Date(StockPurchaseDate) as Date_Link
Resident InvoiceTable;

CalendarMaster:
LOAD

Date(Temp_Date) AS Date_Link,

Year(Temp_Date) AS Year,

'Q' & Ceil(Month(Temp_Date) / 3) AS Quarter, 

Month(Temp_Date) As Month,

Day(Temp_Date) As Day,

Week(Temp_Date) As Week;

Load Date(MinDate + IterNo() -1 ) AS Temp_Date
While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load

Min(Date_Link) AS MinDate,

Max(Date_Link) AS MaxDate

RESIDENT LinkTable;

Use the month generated in the calendar master to create the chart

[naeemmohammed]

Thanks Neelam, its helpful...!

[naeemmohammed]

Thanks ...!