Master Calendar for multiple tables

[anonymous1]

hi, 

i need to create a line chart that shows planned inventory, actual inventory, and predict future inventory, per month.

i have used the planned inventory date field to create the master calendar, but now im struggling to put my actual inventory on the same chart as its not associating with the master calendar. any ideas how i get them both on the same chart?

TIA

[m_woolf]

https://qlikviewcookbook.com/recipes/?download_search=calendar#squelch-taas-accordion-shortcode-cont...

[Vegar · Accepted solution]

The link by @m_woolf is a good read, but depending on how your datamodel you could also look at @hic  blog post about canonical date: https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

The two posts are similar, but slightly different. 

Good luck.