Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

delbooth
New Contributor II

Multiple master calendars and two tables not joined

Hi.

I have two tables one an orders table that has 3 master calendars - date entered,date scheduled and date collected.  I have a separate table that lists dispatches for which i have generated master calendar for dispatches.  The two tables can be plotted as graphs independently but if i want to combine the tables to get:

Tonnes dispatched for a month with tonnes collected for the same month and tonnes entered in the same month.

I have tried using an if statement  =sum(if(CollectMonth=DispatchMonth and DispatchYear='2018',[Quantity Collected],Null())) to try and link the numbers form two master calendars.

Thanks

Del