Master Calendar with multiple dates, linking table

mszuberl — Sat, 11 Jun 2016 05:27:23 GMT

Hi,

I have been working on solving this issue for a long time, and have had no luck.

I hope that one of you, experts, will be able to put me on the right track.

When running the following script:

Master_Calendar_Temp:

LOAD

$(vMinDate) + (RecNo()/24) + (IterNo() - 1) AS Date_Temporary,

//would like to resident load a field here!!

AUTOGENERATE 24 WHILE num($(vMinDate) + IterNo() -1) <= num($(vMaxDate));

is it possible to perform "autogenerate 24" (hourly increments) and Resident Load at the same time?

I need to generate missing hourly intervals for multiple date types, indicated by the DateType field, which I would like to resident load as part of the script.

Or, maybe, there is another way of accomplishing something like this?

Please help!

Marcin

Re: Master Calendar with multiple dates, linking table

swuehl — Sat, 11 Jun 2016 10:16:16 GMT

Could you upload a small, reloadable sample QVW of your current setting?

I assume you are currently using a canonical date (which is a timestamp in your case?) and you want to link the date part and time part of this canonical field to a master calendar / master time table?

Canonical Date

The Master Calendar

The Master Time Table

Tutorial - Using Common Date Dimensions and Shared Calendars

topic Re: Master Calendar with multiple dates, linking table in QlikView

Master Calendar with multiple dates, linking table

Re: Master Calendar with multiple dates, linking table