topic Merge rows excel problem in QlikView https://community.qlik.com/t5/QlikView/Merge-rows-excel-problem/m-p/154774#M31267 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have an excel table that looks like this :</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 436pt; border-collapse: collapse;" width="580"><COLGROUP><COL style="width: 60pt;" width="80" /><COL style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;" width="113" /><COL style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;" width="127" /><COL span="2" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4754;" width="130" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD height="17" style="width: 60pt; height: 12.75pt; background-color: transparent; border: #d4d0c8;" width="80">id</TD><TD style="width: 85pt; background-color: transparent; border: #d4d0c8;" width="113">statut</TD><TD style="width: 95pt; background-color: transparent; border: #d4d0c8;" width="127">date_start</TD><TD style="width: 98pt; background-color: transparent; border: #d4d0c8;" width="130">date_end</TD><TD style="width: 98pt; background-color: transparent; border: #d4d0c8;" width="130">duree</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">demande ouverte</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40299.418055555558">01/05/2010 10:02</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">demande ouverte</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40331.467361111114">02/06/2010 11:13</TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">qualification</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40300.555555555555">02/05/2010 13:20</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id2</TD><TD style="background-color: transparent; border: #d4d0c8;">qualif</TD><TD align="right" class="xl25" style="background-color: transparent; border: #d4d0c8;" num="40300.425000000003">02/05/2010</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id2</TD><TD style="background-color: transparent; border: #d4d0c8;">fermee</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40299.5">01/05/2010 12:00</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40301.517361111109">03/05/2010 12:25</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">25</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>and I want to merge cells to obtain duree (duree= date_end-date_start)</P><P>I have already tryied with interval function</P><P>You can read code with attached file</P><P>Yours faithfully</P></BODY></HTML> Tue, 10 Aug 2010 15:43:58 GMT 2010-08-10T15:43:58Z Merge rows excel problem https://community.qlik.com/t5/QlikView/Merge-rows-excel-problem/m-p/154774#M31267 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have an excel table that looks like this :</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 436pt; border-collapse: collapse;" width="580"><COLGROUP><COL style="width: 60pt;" width="80" /><COL style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;" width="113" /><COL style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;" width="127" /><COL span="2" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4754;" width="130" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD height="17" style="width: 60pt; height: 12.75pt; background-color: transparent; border: #d4d0c8;" width="80">id</TD><TD style="width: 85pt; background-color: transparent; border: #d4d0c8;" width="113">statut</TD><TD style="width: 95pt; background-color: transparent; border: #d4d0c8;" width="127">date_start</TD><TD style="width: 98pt; background-color: transparent; border: #d4d0c8;" width="130">date_end</TD><TD style="width: 98pt; background-color: transparent; border: #d4d0c8;" width="130">duree</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">demande ouverte</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40299.418055555558">01/05/2010 10:02</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">demande ouverte</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40331.467361111114">02/06/2010 11:13</TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id1</TD><TD style="background-color: transparent; border: #d4d0c8;">qualification</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40300.555555555555">02/05/2010 13:20</TD><TD class="xl24" style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id2</TD><TD style="background-color: transparent; border: #d4d0c8;">qualif</TD><TD align="right" class="xl25" style="background-color: transparent; border: #d4d0c8;" num="40300.425000000003">02/05/2010</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">id2</TD><TD style="background-color: transparent; border: #d4d0c8;">fermee</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40299.5">01/05/2010 12:00</TD><TD align="right" class="xl24" style="background-color: transparent; border: #d4d0c8;" num="40301.517361111109">03/05/2010 12:25</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">25</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>and I want to merge cells to obtain duree (duree= date_end-date_start)</P><P>I have already tryied with interval function</P><P>You can read code with attached file</P><P>Yours faithfully</P></BODY></HTML> Tue, 10 Aug 2010 15:43:58 GMT https://community.qlik.com/t5/QlikView/Merge-rows-excel-problem/m-p/154774#M31267 2010-08-10T15:43:58Z