Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hamid
Contributor
Contributor

How to associate 2 tables with diff dates and differents levels

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.

 

2 Replies
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
alex00321
Creator II
Creator II

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