topic Re: Master Calendar With Hour in QlikView

Master Calendar With Hour

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

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?

sunny_talwar — Mon, 24 Jul 2017 23:47:39 GMT

Can you attach your qvw file?

vengadeshpalani — Tue, 25 Jul 2017 01:01:17 GMT

PFA..

sunny_talwar — Tue, 25 Jul 2017 01:09:55 GMT

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;