topic Re: How to associate 2 tables with diff dates and differents levels in QlikView

How to associate 2 tables with diff dates and differents levels

hamid — Tue, 11 Feb 2020 16:52:47 GMT

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.

Re: How to associate 2 tables with diff dates and differents levels

Brett_Bleess — Tue, 10 Mar 2020 20:15:37 GMT

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

Re: How to associate 2 tables with diff dates and differents levels

alex00321 — Wed, 11 Mar 2020 09:23:32 GMT

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