topic Re. :excel cell merge in QlikView https://community.qlik.com/t5/QlikView/excel-cell-merge/m-p/153574#M30564 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can try with :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">interval(date_start-date_end)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 09 Aug 2010 15:35:36 GMT martin59 2010-08-09T15:35:36Z excel cell merge https://community.qlik.com/t5/QlikView/excel-cell-merge/m-p/153573#M30563 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Hi,</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"></P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">I have an excel table that looks like this (or see attached file for )</P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="width: 425pt; border-collapse: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="567"><TBODY><TR style="height: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="width: 60pt; height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;" width="80"><P style="margin: 6pt;">id</P></TD><TD style="width: 85pt; height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;" width="113"><P style="margin: 6pt;">statut</P></TD><TD style="width: 84pt; height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;" width="112"><P style="margin: 6pt;">date_start</P></TD><TD style="width: 98pt; height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;" width="131"><P style="margin: 6pt;">date_end</P></TD><TD style="width: 98pt; height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;" width="131"><P style="margin: 6pt;">duree</P></TD></TR><TR style="height: 12.75pt; mso-yfti-irow: 1;"><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">id1</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">demande ouverte</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt; text-align: right">01/05/2010 10:02</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">-</P></TD></TR><TR style="height: 12.75pt; mso-yfti-irow: 2;"><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">id1</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">demande ouverte</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt; text-align: right">02/06/2010 11:13</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">-</P></TD></TR><TR style="height: 12.75pt; mso-yfti-irow: 3;"><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">id2</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">qualif</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt; text-align: right">02/05/2010</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">-</P></TD></TR><TR style="height: 12.75pt; mso-yfti-irow: 4;"><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">id2</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">qualif</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt; text-align: right">03/05/2010 12:25</P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;">-</P></TD></TR><TR style="height: 12.75pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD><TD style="height: 12.75pt; background-color: transparent; border: #d4d0c8; padding: 0cm;"><P style="margin: 6pt;"></P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">and I want to merge cells to obtain duree (duree= date_end-date_start)</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"></P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"></P><P></P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Yours faithfully</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Regards</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"></P><BR /><BR /> <P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"></P></BODY></HTML> Mon, 09 Aug 2010 15:19:29 GMT https://community.qlik.com/t5/QlikView/excel-cell-merge/m-p/153573#M30563 2010-08-09T15:19:29Z Re. :excel cell merge https://community.qlik.com/t5/QlikView/excel-cell-merge/m-p/153574#M30564 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can try with :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">interval(date_start-date_end)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 09 Aug 2010 15:35:36 GMT https://community.qlik.com/t5/QlikView/excel-cell-merge/m-p/153574#M30564 martin59 2010-08-09T15:35:36Z