topic Re: Master calendar in QlikView

Master calendar

Anonymous — Fri, 08 May 2015 14:56:47 GMT

Hi,

I am looking to add to the standard Master Calendar code, additional granularity of 1 - 24 hours in a day.

Not so sure how to code it.

Thanks

Re: Master calendar

Gysbert_Wassenaar — Fri, 08 May 2015 17:21:00 GMT

Perhaps you should create a Master Time table instead: The Master Time Table‌. Otherwise you'll increase the size of your Master Calendar table by a factor of 24.

Re: Master calendar

maxgro — Fri, 08 May 2015 18:04:32 GMT

d: load rowno() as id, date(makedate(2015) + rowno()-1) as d AutoGenerate 365;

left join (d) load (rowno()-1)/24 as h AutoGenerate 24;

d2: load Timestamp(d + h) as dh Resident d;

DROP Table d;