Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
delbooth
Contributor II
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

0 Replies