topic Split records by predefined time ranges in QlikView https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/870667#M304356 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i would like to split records by predefined time ranges. I got two tables, one for the time ranges and one for the actions:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87813_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Every time a record overlaps one or more time ranges, new ranges should be created:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID_NEW</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>StartTime</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EndTime</STRONG></TH></TR><TR><TD style="padding: 2px;">1_1</TD><TD style="padding: 2px;">05:37</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">1_2</TD><TD style="padding: 2px;">08:01</TD><TD style="padding: 2px;">09:10</TD></TR><TR><TD style="padding: 2px;">2_1</TD><TD style="padding: 2px;">08:45</TD><TD style="padding: 2px;">12:00</TD></TR><TR><TD style="padding: 2px;">2_2</TD><TD style="padding: 2px;">12:01</TD><TD style="padding: 2px;">12:15</TD></TR></TBODY></TABLE><P></P><P>I'm grateful for any ideas! Best regards!!</P><P></P><P>QVW attached</P></BODY></HTML> Thu, 28 May 2015 13:55:00 GMT 2015-05-28T13:55:00Z Split records by predefined time ranges https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/870667#M304356 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i would like to split records by predefined time ranges. I got two tables, one for the time ranges and one for the actions:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87813_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Every time a record overlaps one or more time ranges, new ranges should be created:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID_NEW</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>StartTime</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EndTime</STRONG></TH></TR><TR><TD style="padding: 2px;">1_1</TD><TD style="padding: 2px;">05:37</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">1_2</TD><TD style="padding: 2px;">08:01</TD><TD style="padding: 2px;">09:10</TD></TR><TR><TD style="padding: 2px;">2_1</TD><TD style="padding: 2px;">08:45</TD><TD style="padding: 2px;">12:00</TD></TR><TR><TD style="padding: 2px;">2_2</TD><TD style="padding: 2px;">12:01</TD><TD style="padding: 2px;">12:15</TD></TR></TBODY></TABLE><P></P><P>I'm grateful for any ideas! Best regards!!</P><P></P><P>QVW attached</P></BODY></HTML> Thu, 28 May 2015 13:55:00 GMT https://community.qlik.com/t5/QlikView/Split-records-by-predefined-time-ranges/m-p/870667#M304356 2015-05-28T13:55:00Z