topic Re: How to Create a single Master Calendar in QlikView

How to Create a single Master Calendar

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can you please advise me how to create a Single MASTER calendar for the below data model. All the tables are have own date fields but dates are not common, My output is in front end side if I select Year and Month all the charts are need to display the values .

Regards,

Sunni

Re: How to Create a single Master Calendar

santiago_respane — Thu, 11 Aug 2016 14:14:47 GMT

Hi,

i recommend you to start from here Creating A Master Calendar

Kind regards,

Re: How to Create a single Master Calendar

marcus_sommer — Thu, 11 Aug 2016 15:25:01 GMT

I think you will need several calendars and also a canonical calendar:

Canonical Date

Why You sometimes should Load a Master Table several times‌

- Marcus

Re: How to Create a single Master Calendar

Fri, 12 Aug 2016 08:00:59 GMT

Hi Marcus ,

I have tried to apply the given concept but no use ,nothing will come up as my expectation . Can you please guide me or provide any one of example so that I can correct it where did I wrong .

Re: How to Create a single Master Calendar

marcus_sommer — Fri, 12 Aug 2016 09:16:23 GMT

That is definetely not a easy task especially by such a complex datamodel like yours. I suggest that you try to implement it step by step at first with only two single calendars which you then merged into a canonical calendar to understand better how it worked and what is possible then quite probably won't be all wished views possible. A big topic here is if you have for all calendars the right keys and those have then all needed values?

You will need some time to play with these concepts. Here is another one which might more suitable for you: Linking to two or more dates.

- Marcus

Re: How to Create a single Master Calendar

Fri, 12 Aug 2016 14:48:37 GMT

Marcus ,

I completely agree with you ,it is very hard to implement single master calendar for this type of data model and more over the date filed values are not common.Yes,I have created calendar separateley and merged together and based on that field using to generated canonical calendar but when I selecting the calendar dates charts are behaving strangely

I am not getting any idea out of it and tried many ways but no luck