topic Link by dates in QlikView https://community.qlik.com/t5/QlikView/Link-by-dates/m-p/1401781#M612841 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I hope the community experts can help me on this.</P><P></P><P>I Have the follow situation:</P><P></P><P>Table SatO2</P><P><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SatO2</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:01:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">......</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 11:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99</SPAN></P><P></P><P>Table FiO2</P><P><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FiO2</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 09:30:00&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:15:00&nbsp;&nbsp;&nbsp;&nbsp; 25</SPAN></P><P></P><P>I need to join the tables based on the date so that the FiO2 value will value between to date/time without changing the number of registers of SatO2 table. This way:</P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SatO2&nbsp;&nbsp; FiO2</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21 </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:01:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">......</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 11:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am stucked to join the two tables without a complete FK</P><P style="font-size: 13.3333px;">I would really apreciate your help.</P><P style="font-size: 13.3333px;">An working example would be great ! !</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Regards,</P><P style="font-size: 13.3333px;">Itamar</P></BODY></HTML> Thu, 05 Oct 2017 14:09:00 GMT 2017-10-05T14:09:00Z Link by dates https://community.qlik.com/t5/QlikView/Link-by-dates/m-p/1401781#M612841 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I hope the community experts can help me on this.</P><P></P><P>I Have the follow situation:</P><P></P><P>Table SatO2</P><P><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SatO2</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:01:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">......</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 11:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99</SPAN></P><P></P><P>Table FiO2</P><P><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FiO2</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 09:30:00&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:15:00&nbsp;&nbsp;&nbsp;&nbsp; 25</SPAN></P><P></P><P>I need to join the tables based on the date so that the FiO2 value will value between to date/time without changing the number of registers of SatO2 table. This way:</P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">Patient ID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SatO2&nbsp;&nbsp; FiO2</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21 </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:00:30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 10:01:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">......</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-family: 'courier new', courier;">1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10 11:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am stucked to join the two tables without a complete FK</P><P style="font-size: 13.3333px;">I would really apreciate your help.</P><P style="font-size: 13.3333px;">An working example would be great ! !</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Regards,</P><P style="font-size: 13.3333px;">Itamar</P></BODY></HTML> Thu, 05 Oct 2017 14:09:00 GMT https://community.qlik.com/t5/QlikView/Link-by-dates/m-p/1401781#M612841 2017-10-05T14:09:00Z