How to associate 2 tables with diff dates and differents levels

[hamid]

Hi,

I want to create a combo chart that display by month year, number of targeted event that we have by region level, so the table contains total by region and year for that we divide by 12 to display by month and we display accumulated line chart.

in same chart we need to calculate number of event planned and number of event performed.

I tried a solution that create a common master calendar for the 3 dates following this post https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

But the issue is that the key is different from table 1 and 2 as the table 1 on region level and table 2 is on event level.

Could someone help on this please.

I attached a sample date.

[Brett_Bleess]

Have a look at the following Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

If neither of those help further, here is the base URL to the area you can use to further search for other posts that may be helpful, but I am hopeful one of the above may bet you what you need to move things forward.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[alex00321]

I try to combine the 2 table into 1, you could check attached file to see if that helps.