Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
naeemmohammed
Contributor II
Contributor II

Common Date (Year, Month)

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

Tables.png

Result.png

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

this might be helpful -

Credit - rwunderlich

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

View solution in original post

5 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

can you provide sample data?

QlikView Qlik Sense consultant
neelamsaroha157
Specialist II
Specialist II

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
Specialist
Specialist

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
Contributor II
Contributor II
Author

Thanks Neelam, its helpful...!

naeemmohammed
Contributor II
Contributor II
Author

Thanks ...!