Master Calender

khadar — Thu, 20 Jan 2022 10:13:16 GMT

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 !!

Re: Master Calender

vikasmahajan — Thu, 20 Jan 2022 10:19:53 GMT

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

topic Re: Master Calender in App Development

Master Calender

Re: Master Calender