Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Master Calendar with every 30 Minutes

MVP
MVP

Master Calendar with every 30 Minutes

Hi All,

Please find below script for generating the Master Calendar with every 30 minutes

LET vMinDate = Num(MakeDate(2014,1,1));  // Calendar Start Date

LET vMaxDate = Num(Today()); // Calendar End Date

LET vDays = vMaxDate - vMinDate + 2;  // Calculating number of days between Start & End Dates

Calendar:

LOAD Date(Floor(TimeStamp)) AS Date,

TimeStamp,

Hour(TimeStamp) AS Hour,

Minute(TimeStamp) AS Minute;

LOAD

    Timestamp($(vMinDate) + (RecNo() - 1)/48) as TimeStamp

AUTOGENERATE 48 * $(vDays);

Hope this helps.

Regards,

jagan.

Comments
lornafnb
Valued Contributor

Jagan,

Excellent work thanks.

May I ask what the following means - and what the figure mean?

thanks!

    Timestamp($(vMinDate) + (RecNo() - 1)/48) as TimeStamp

AUTOGENERATE 48 * $(vDays);

Version history
Revision #:
1 of 1
Last update:
‎09-03-2015 11:10 AM
Updated by: