Master Calender

[khadar]

Hi All,

 Need small help on master calender. I have 5 different tables in my data model each table has it's own data feild.

here, I want to create the master and map to the all others tables. Intially I have created the master calender and I have drived year, month & week  from master calender to create the association between master calender I have giving same Yaer,month as column names in other tables. since having more than 2 common columns in 5 tables syn key is generating.

can someone please help me to map my master calender to other tables 

Thanks in advance !!

[vikasmahajan · Accepted solution]

Hi,

1. Please find attached master calendar script which you can use in your app using min & max date.

2. you common columns you need to create link table please refer following link for more in details:

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Hope this help you.

Vikas