topic Group by in QlikView https://community.qlik.com/t5/QlikView/Group-by/m-p/1805989#M1212097 <P>Hi !</P><P>&nbsp;</P><P>I have the following database (with a lot of case numbers):</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Case_Number</TD><TD>Date</TD><TD>Area</TD><TD>Status</TD></TR><TR><TD>279</TD><TD>14/7/2016 11:42:10</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:22</TD><TD>Operaciones</TD><TD>Solicitud&nbsp; Reasignada por Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:49</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 10:32:46</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 18:37:19</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade</TD></TR><TR><TD>279</TD><TD>20/7/2016 9:42:59</TD><TD>DDC</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade</TD></TR><TR><TD>279</TD><TD>25/7/2016 15:05:57</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR><TR><TD>279</TD><TD>26/7/2016 16:44:11</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR><TR><TD>280</TD><TD>15/7/2016 12:03:07</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:03:32</TD><TD>Operaciones</TD><TD>Solicitud&nbsp; Reasignada por Operaciones</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:04:29</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:44:00</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>280</TD><TD>18/7/2016 18:59:41</TD><TD>Actuarial</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 15:04:29</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 15:05:44</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 16:17:19</TD><TD>Call Center Telesales</TD><TD>Riesgo Extraprimado - Consulta al Cliente</TD></TR><TR><TD>280</TD><TD>27/7/2016 12:01:40</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado - Consulta al Cliente - Aceptada</TD></TR><TR><TD>280</TD><TD>27/7/2016 16:37:59</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado - Consulta al Cliente - Aceptada</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So a case enter in an area, then some procedures happen and goes to another area.</P><P>I need to summarize the database. Grouping by "Area" and in date, having the minimal date (the date a case number entered in the area). The problem is that a case number, can enter an Area, exit, go to another area and then come back. For example: Operaciones. I need to keep the sequence.</P><P>&nbsp;</P><P>The result for the case "279" would be:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Case_Number</TD><TD>Date</TD><TD>Area</TD><TD>Status</TD></TR><TR><TD>279</TD><TD>14/7/2016 11:42:10</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:49</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 10:32:46</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 18:37:19</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade</TD></TR><TR><TD>279</TD><TD>20/7/2016 9:42:59</TD><TD>DDC</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade</TD></TR><TR><TD>279</TD><TD>25/7/2016 15:05:57</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>If you could help me with this I would really appreciate!</P> Thu, 06 May 2021 20:41:40 GMT Frquiroga1995 2021-05-06T20:41:40Z Group by https://community.qlik.com/t5/QlikView/Group-by/m-p/1805989#M1212097 <P>Hi !</P><P>&nbsp;</P><P>I have the following database (with a lot of case numbers):</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Case_Number</TD><TD>Date</TD><TD>Area</TD><TD>Status</TD></TR><TR><TD>279</TD><TD>14/7/2016 11:42:10</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:22</TD><TD>Operaciones</TD><TD>Solicitud&nbsp; Reasignada por Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:49</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 10:32:46</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 18:37:19</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade</TD></TR><TR><TD>279</TD><TD>20/7/2016 9:42:59</TD><TD>DDC</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade</TD></TR><TR><TD>279</TD><TD>25/7/2016 15:05:57</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR><TR><TD>279</TD><TD>26/7/2016 16:44:11</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR><TR><TD>280</TD><TD>15/7/2016 12:03:07</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:03:32</TD><TD>Operaciones</TD><TD>Solicitud&nbsp; Reasignada por Operaciones</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:04:29</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>280</TD><TD>18/7/2016 10:44:00</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>280</TD><TD>18/7/2016 18:59:41</TD><TD>Actuarial</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 15:04:29</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 15:05:44</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado</TD></TR><TR><TD>280</TD><TD>21/7/2016 16:17:19</TD><TD>Call Center Telesales</TD><TD>Riesgo Extraprimado - Consulta al Cliente</TD></TR><TR><TD>280</TD><TD>27/7/2016 12:01:40</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado - Consulta al Cliente - Aceptada</TD></TR><TR><TD>280</TD><TD>27/7/2016 16:37:59</TD><TD>Operaciones</TD><TD>Riesgo Extraprimado - Consulta al Cliente - Aceptada</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So a case enter in an area, then some procedures happen and goes to another area.</P><P>I need to summarize the database. Grouping by "Area" and in date, having the minimal date (the date a case number entered in the area). The problem is that a case number, can enter an Area, exit, go to another area and then come back. For example: Operaciones. I need to keep the sequence.</P><P>&nbsp;</P><P>The result for the case "279" would be:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Case_Number</TD><TD>Date</TD><TD>Area</TD><TD>Status</TD></TR><TR><TD>279</TD><TD>14/7/2016 11:42:10</TD><TD>Operaciones</TD><TD>Pendiente Operaciones</TD></TR><TR><TD>279</TD><TD>15/7/2016 14:46:49</TD><TD>Operaciones_UW</TD><TD>Pendiente Operaciones_UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 10:32:46</TD><TD>UW</TD><TD>Pendiente UW</TD></TR><TR><TD>279</TD><TD>18/7/2016 18:37:19</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade</TD></TR><TR><TD>279</TD><TD>20/7/2016 9:42:59</TD><TD>DDC</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade</TD></TR><TR><TD>279</TD><TD>25/7/2016 15:05:57</TD><TD>Operaciones</TD><TD>Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>If you could help me with this I would really appreciate!</P> Thu, 06 May 2021 20:41:40 GMT https://community.qlik.com/t5/QlikView/Group-by/m-p/1805989#M1212097 Frquiroga1995 2021-05-06T20:41:40Z Re: Group by https://community.qlik.com/t5/QlikView/Group-by/m-p/1806180#M1212113 <P>Good morning&nbsp;</P><P>have you tried</P><P>LOAD&nbsp;</P><P>Case_Number,</P><P>Area,</P><P>Status,</P><P>min(Date) as Date</P><P>group by&nbsp; &nbsp;Case_Number,Area,Status</P><P>RESIDENT x.xlsx</P> Fri, 07 May 2021 13:21:57 GMT https://community.qlik.com/t5/QlikView/Group-by/m-p/1806180#M1212113 yassinemhadhbi 2021-05-07T13:21:57Z