topic Merge generated calendars into one table in Archived Groups

Merge generated calendars into one table

Tue, 22 Jul 2025 17:59:49 GMT

Hi,

I'm attempting to use the calendar generation within the Deployment Framework. We had a change to the start of our fiscal year (from September to January) and so the calendars need to be able to reflect that when selecting different quarters etc.

I've been able to generate the calendars separately but is there any way that these can be merged into a single table? Or if not does anyone know how i could get round this another way. I'm planning on generating a calendar for the crossover period (where we ended up with an extra quarter in a year) manually, as i expect that an automatic generation wouldn't accommodate this.

Thanks

Re: Merge generated calendars into one table

marcus_sommer — Tue, 27 May 2014 10:06:53 GMT

Normally such merging will be done per concatenating from both tables/calendars and adding a flag field which contained the type of calendar. Then you could simply select which calendar you want to use. But I'm not sure if there any side effects for you ...

Maybe these could be also helpful: http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

- Marcus

Re: Merge generated calendars into one table

Tue, 27 May 2014 10:47:41 GMT

Thanks for the reply, i've managed to concatenate them together and it all appears to be fine.

Thanks for your help, and also for the link, its a very interesting read.