Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Creator III
Creator III

can you provide sample data?

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

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 ...!