topic Re: Split records by predefined time ranges in QlikView https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/871558#M1005654 <HTML><HEAD></HEAD><BODY><P>This should be helpful for you:</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P></P><P>and don't make double postings: <A href="https://community.qlik.com/thread/165937">Split records by predefined time ranges</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 28 May 2015 15:54:07 GMT marcus_sommer 2015-05-28T15:54:07Z Split records by predefined time ranges https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/871557#M1005653 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i would like to split and create new records by predefined time ranges. I got two tables, one for the periods, one for the actions.</P><P>New records should be created when an action overlaps with one or more time ranges (see table below)!</P><P>QVW is attached.</P><P></P><P>I'm grateful for any ideas!</P><P></P><P>Best regards!</P><P></P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="192" style="width: 208px; height: 146px;"><TBODY><TR><TD class="xl63" height="20" width="80">ID_NEW</TD><TD class="xl63" width="80">StartTime</TD><TD width="80">EndTime</TD></TR><TR><TD height="20">1_1</TD><TD align="right" class="xl63">05:37:00</TD><TD align="right" class="xl63">08:00:00</TD></TR><TR><TD height="20">1_2</TD><TD align="right" class="xl63">08:01:00</TD><TD align="right" class="xl63">09:10:00</TD></TR><TR><TD height="20">2_1</TD><TD align="right" class="xl63">08:45:00</TD><TD align="right" class="xl63">12:00:00</TD></TR><TR><TD height="20">2_2</TD><TD align="right" class="xl63">12:01:00</TD><TD align="right" class="xl63">12:15:00</TD></TR><TR><TD height="20">3_1</TD><TD align="right" class="xl63">13:05:00</TD><TD align="right" class="xl63">14:00:00</TD></TR><TR><TD height="20">3_2</TD><TD align="right" class="xl63">14:01:00</TD><TD align="right" class="xl63">18:00:00</TD></TR><TR><TD height="20">3_3</TD><TD align="right" class="xl63">18:01:00</TD><TD align="right" class="xl63">21:10:00</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 28 May 2015 13:13:59 GMT https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/871557#M1005653 2015-05-28T13:13:59Z Re: Split records by predefined time ranges https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/871558#M1005654 <HTML><HEAD></HEAD><BODY><P>This should be helpful for you:</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P></P><P>and don't make double postings: <A href="https://community.qlik.com/thread/165937">Split records by predefined time ranges</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 28 May 2015 15:54:07 GMT https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/871558#M1005654 marcus_sommer 2015-05-28T15:54:07Z