topic Re: Master Calendar for multiple tables in QlikView

Master Calendar for multiple tables

anonymous1 — Sat, 16 Nov 2024 03:00:15 GMT

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

Re: Master Calendar for multiple tables

m_woolf — Mon, 15 Jul 2019 14:23:20 GMT

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

Re: Master Calendar for multiple tables

Vegar — Mon, 15 Jul 2019 16:35:59 GMT

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.