Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
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
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