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: 
vengadeshpalani
Creator
Creator

Master Calendar With Hour

hi all

i try to create a master calendar with Hour 

LET vMinDate = num(Timestamp(Timestamp#('05/05/2015 05:05:05','MM/DD/YYYY hh:mm:ss')));

LET vMaxDate = num(Timestamp(Timestamp#('05/06/2015 15:05:05','MM/DD/YYYY hh:mm:ss')));

LET vDays = vMaxDate - vMinDate ;

Calendar:

LOAD Year(KeyDate) as Year,

Date(MonthName(KeyDate),'MMM/YYYY') as MonthYear,

Month(KeyDate) as Month,

Day(KeyDate) as Day,

Date(Floor(Date(KeyDate,'MM/DD/YYYY')),'MM/DD/YYYY') as Date,

Hour(KeyDate) AS Hour,

Timestamp(Floor(KeyDate, 1/24),'MM/DD/YYYY HH') as KeyDate;

LOAD

    Timestamp($(vMinDate) + (RecNo()-1)/24) as KeyDate

AUTOGENERATE 24 * $(vDays);

Max date Max hour is 15 but Hour 15 is not associated with Date what i did wrong?

master cal.png

1 Solution

Accepted Solutions
sunny_talwar

I think you were adding one less hour

LET vMinDate = num(Timestamp(Timestamp#('05/05/2015 05:05:05','MM/DD/YYYY hh:mm:ss')));

LET vMaxDate = num(Timestamp(Timestamp#('05/06/2015 15:05:05','MM/DD/YYYY hh:mm:ss')));

LET vDays = vMaxDate - vMinDate ;

Calendar:

LOAD Year(KeyDate) as Year,

Date(MonthName(KeyDate),'MMM/YYYY') as MonthYear,

Month(KeyDate) as Month,

Day(KeyDate) as Day,

Date(Floor(Date(KeyDate,'MM/DD/YYYY')),'MM/DD/YYYY') as Date,

Hour(KeyDate) AS Hour,

Timestamp(Floor(KeyDate, 1/24),'MM/DD/YYYY HH') as KeyDate;

LOAD

    Timestamp($(vMinDate) + (RecNo()-1)/24) as KeyDate

AUTOGENERATE 24 * $(vDays) + 1;

View solution in original post

3 Replies
sunny_talwar

Can you attach your qvw file?

vengadeshpalani
Creator
Creator
Author

PFA..

sunny_talwar

I think you were adding one less hour

LET vMinDate = num(Timestamp(Timestamp#('05/05/2015 05:05:05','MM/DD/YYYY hh:mm:ss')));

LET vMaxDate = num(Timestamp(Timestamp#('05/06/2015 15:05:05','MM/DD/YYYY hh:mm:ss')));

LET vDays = vMaxDate - vMinDate ;

Calendar:

LOAD Year(KeyDate) as Year,

Date(MonthName(KeyDate),'MMM/YYYY') as MonthYear,

Month(KeyDate) as Month,

Day(KeyDate) as Day,

Date(Floor(Date(KeyDate,'MM/DD/YYYY')),'MM/DD/YYYY') as Date,

Hour(KeyDate) AS Hour,

Timestamp(Floor(KeyDate, 1/24),'MM/DD/YYYY HH') as KeyDate;

LOAD

    Timestamp($(vMinDate) + (RecNo()-1)/24) as KeyDate

AUTOGENERATE 24 * $(vDays) + 1;