Discussion board where members can get started with QlikView.
i try to get hour field in master calendar but Master calendar link key is not mapping with Data Tables
What i did wrong? why its duplicated?
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink,
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink1,
(biff, embedded labels, table is Sheet1$);
LOAD Year(TimeStamp) as Year,
MonthName(TimeStamp) as MonthYear,
Month(TimeStamp) as Month,
Day(TimeStamp) as Day,
Date( Floor( Date(TimeStamp)),'MM/DD/YYYY') as Date,
Hour(TimeStamp) AS Hour,
Timestamp(Floor(TimeStamp, 1/24),'MM/DD/YYYY HH') as MasCalLink ;
Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp
AUTOGENERATE 23 * $(vDays);
View solution in original post
That's because you only formatted the text representation, and the numeric part kept unchanged (and the numeric part is used for the key match).
try to adapt the numeric part, too, e.g.
Timestamp#(Timestamp(TimeStamp,'MM/DD/YYYY HH'),'MM/DD/YYYY HH') as MasCalLink
How below code works
Can you please explain
For a fixed series of vDays full day calendar entries (all hours), you may want to change the 23 into 24.