Master Calendar creation

konidena — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a data model which contains patient admitted date and discharged date. I am maintaining these 2 dates in fact table.

I am not having all the dates in a year as patient admitted and discharged dates.

My requirement is , i have to create master calendar. I considered the minimum date is minimum date from patient admitted date.

Maximum date is maximum of patient discharged date.

Now, i need to have Year, Quarter, Month, Week.

Please suggest me on how to create the master calendar to show all the dates.

Regards

Srini

Re: Master Calendar creation

Gysbert_Wassenaar — Wed, 13 Apr 2016 11:28:25 GMT

You can link one master calendar only to one date field. You have two. So perhaps you want two calendars. Otherwise you may need to remodel your data so that you have only one date field, optionally with a field that specifies which kind of date the record stores. You could for example create records for each day a patient was submitted between the admission and discharge dates. How to do that is explained in this blog post: Creating Reference Dates for Intervals

For more information about using multiple versus single master calendars see these pages and the comments on those pages:

Master calendar‌

The Master Calendar‌

topic Master Calendar creation in QlikView

Master Calendar creation

Re: Master Calendar creation