topic Re: Common Date (Year, Month) in QlikView

Common Date (Year, Month)

naeemmohammed — Fri, 14 Sep 2018 14:56:22 GMT

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);

Re: Common Date (Year, Month)

kfoudhaily — Fri, 14 Sep 2018 15:47:28 GMT

can you provide sample data?

Re: Common Date (Year, Month)

neelamsaroha157 — Fri, 14 Sep 2018 15:51:21 GMT

this might be helpful -

Credit - rwunderlich‌

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

Re: Common Date (Year, Month)

vamsee — Fri, 14 Sep 2018 15:53:50 GMT

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

Re: Common Date (Year, Month)

naeemmohammed — Fri, 14 Sep 2018 16:05:58 GMT

Thanks Neelam, its helpful...!

Re: Common Date (Year, Month)

naeemmohammed — Fri, 14 Sep 2018 16:08:19 GMT

Thanks ...!