topic Re: Intervall between dates in two diffrent tables, should I concatenate or how to do it? in QlikView https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384312#M1166628 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Thank´s for the post, It´s really helpfull.&nbsp; </P></BODY></HTML> Wed, 05 Sep 2012 13:01:50 GMT 2012-09-05T13:01:50Z Intervall between dates in two diffrent tables, should I concatenate or how to do it? https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384310#M1166626 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have several tables linked with diffrent keys to a facttable. Two of the tables, we can call them, Order and Delivery holds dates and many common fields like CustomID, CaseID, OfficeDepartment etc. I would like to know how many days from Order to Delivery and the also avg days. The Deliverytable holds a statusfield (status = 1, 2, 4 ...) that the avg days should reflect. </P><P></P><P>How is this best done? Should I concatenate them(or use join/left join etc) into one table i the tranforms step or link them throgh the facttable in the finally load? I´m not so in to the diffrenses between join/left join and concatenate so I can´t clearly see how I should do.&nbsp; </P></BODY></HTML> Wed, 05 Sep 2012 09:23:14 GMT https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384310#M1166626 2012-09-05T09:23:14Z Re: Intervall between dates in two diffrent tables, should I concatenate or how to do it? https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384311#M1166627 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>maybe this thread will help you, to understand the differences: <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/127930#127930">http://community.qlik.com/message/127930#127930</A></P><P></P><P>I would use the join or left join to make one table. </P><P></P><P>Regards</P></BODY></HTML> Wed, 05 Sep 2012 11:47:42 GMT https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384311#M1166627 2012-09-05T11:47:42Z Re: Intervall between dates in two diffrent tables, should I concatenate or how to do it? https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384312#M1166628 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Thank´s for the post, It´s really helpfull.&nbsp; </P></BODY></HTML> Wed, 05 Sep 2012 13:01:50 GMT https://community.qlik.com/t5/QlikView/Intervall-between-dates-in-two-diffrent-tables-should-I/m-p/384312#M1166628 2012-09-05T13:01:50Z