Joining two dates from two different tables

[faith04]

Hi all, 

I have two different tables and want to combine the dates(monthly) from theses tables together to compare three different fields from them. One table contains number of orders made by customers and the amount supplied to the customers. The other table shows the total amount the farm produces.

So I want to compare all three fields in one chart (bar or line), i.e. orders made, orders supplied and the total produce  for the same time period. I have already changed the dates to one format and tried to join the the tables but the fields from one table are still separate from the other table when creating the line/bar chart

Any suggestions will be greatly appreciated

Many thanks

[vinieme12]

please post some sample data that best represents your actual dataset

But it seems like you need a canonical calendar

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

[vikasmahajan]

Hi,

Here is a detail explaination with demo for Link table.

https://community.qlik.com/t5/Qlik-Sense-Documents/link-table/ta-p/1883375