Merge generated calendars into one table

[#1]

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

[marcus_sommer · Accepted solution]

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

[#3]

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.