topic Grouping by continuous dates in QlikView

topic Grouping by continuous dates in QlikView https://community.qlik.com/t5/QlikView/Grouping-by-continuous-dates/m-p/492772#M693470 <HTML><HEAD></HEAD><BODY><P>Hi !<BR />I have a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 80%; border: 1px solid #000000;"><TBODY><TR><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>Step</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>Start</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>End</STRONG></SPAN></TH></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 1</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:01:43</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:11:17</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 2</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:11:17</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:16:29</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 3</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:16:29</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;"><P>16/06/2013  10:47:30</P></TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 4</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  11:05:20</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:05:45</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 5</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:05:45</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:14:09</TD></TR></TBODY></TABLE><P></P><P></P><P>In the LOAD process I would like to finish with this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 80%; border: 1px solid #000000;"><TBODY><TR><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>Time</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>Start</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>End</STRONG></SPAN></TH></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">01:45:47</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">16/06/2013 09:01:43</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">16/06/2013 10:47:30</TD></TR></TBODY></TABLE><P></P><P>Steps 4 and 5 are not selected because they sum less then 15 minutes.<BR />Is it possible to achieve this ?</P><P></P><P>Thanks in advance !</P><P></P><P>Regards,<BR />Itamar</P></BODY></HTML> Thu, 20 Jun 2013 13:33:07 GMT 2013-06-20T13:33:07Z Grouping by continuous dates https://community.qlik.com/t5/QlikView/Grouping-by-continuous-dates/m-p/492772#M693470 <HTML><HEAD></HEAD><BODY><P>Hi !<BR />I have a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 80%; border: 1px solid #000000;"><TBODY><TR><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>Step</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>Start</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #ffffff; text-align: center; padding: 3px;"><SPAN style="color: #ffffff;"><STRONG>End</STRONG></SPAN></TH></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 1</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:01:43</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:11:17</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 2</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:11:17</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:16:29</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 3</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  09:16:29</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;"><P>16/06/2013  10:47:30</P></TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 4</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013  11:05:20</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:05:45</TD></TR><TR><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">Step 5</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:05:45</TD><TD style="color: #333333; text-align: left; padding: 3px; background-color: transparent; font-family: arial, helvetica, sans-serif;">16/06/2013 11:14:09</TD></TR></TBODY></TABLE><P></P><P></P><P>In the LOAD process I would like to finish with this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 80%; border: 1px solid #000000;"><TBODY><TR><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>Time</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>Start</STRONG></SPAN></TH><TH style="background-color: #6690bc; color: #333333; text-align: -webkit-center; padding: 3px; font-family: arial, helvetica, sans-serif;"><SPAN style="color: #ffffff;"><STRONG>End</STRONG></SPAN></TH></TR><TR><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">01:45:47</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">16/06/2013 09:01:43</TD><TD style="color: #000000; text-align: left; padding: 3px; background-color: transparent;">16/06/2013 10:47:30</TD></TR></TBODY></TABLE><P></P><P>Steps 4 and 5 are not selected because they sum less then 15 minutes.<BR />Is it possible to achieve this ?</P><P></P><P>Thanks in advance !</P><P></P><P>Regards,<BR />Itamar</P></BODY></HTML> Thu, 20 Jun 2013 13:33:07 GMT https://community.qlik.com/t5/QlikView/Grouping-by-continuous-dates/m-p/492772#M693470 2013-06-20T13:33:07Z