Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mszuberl
New Contributor II

Master Calendar with multiple dates, linking table

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

1 Reply
MVP
MVP

Re: Master Calendar with multiple dates, linking table

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

Community Browser