Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
anonymous1
New Contributor III

Master Calendar for multiple tables

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Master Calendar for multiple tables

The link by @mwoolf is a good read, but depending on how your datamodel you could also look at @Henric_Cronström  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.

???
Celebrating my 300 accepted solution in the Qlik Community
???
2 Replies
mwoolf
Honored Contributor II

Re: Master Calendar for multiple tables

Partner
Partner

Re: Master Calendar for multiple tables

The link by @mwoolf is a good read, but depending on how your datamodel you could also look at @Henric_Cronström  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.

???
Celebrating my 300 accepted solution in the Qlik Community
???