Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today

Master Calendar with every 30 Minutes

MVP & Luminary
MVP & Luminary

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.

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