topic Add rows in table between start and enddate for every minute in QlikView

topic Add rows in table between start and enddate for every minute in QlikView https://community.qlik.com/t5/QlikView/Add-rows-in-table-between-start-and-enddate-for-every-minute/m-p/52035#M8639 <HTML><HEAD></HEAD><BODY><P>Hello to all,</P><P>from a table made like this :</P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 511px;"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="130">StartDate</TD><TD class="xl63" style="border-left: none;" width="130">EndDate</TD><TD class="xl63" style="border-left: none;" width="70">Ora_inizio</TD><TD class="xl63" style="border-left: none;" width="61">Ora_fine</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">a</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl65" style="border-top: none; border-left: none;">09:59</TD><TD class="xl65" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">b</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl65" style="border-top: none; border-left: none;">09:02</TD><TD class="xl65" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">c</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl65" style="border-top: none; border-left: none;">09:03</TD><TD class="xl65" style="border-top: none; border-left: none;">09:05</TD></TR></TBODY></TABLE><P></P><P>I would like to have a table like that:</P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 455px;"><TBODY><TR><TD class="xl65" height="20" width="64">ID</TD><TD class="xl65" style="border-left: none;" width="130">StartDate</TD><TD class="xl65" style="border-left: none;" width="130">EndDate</TD><TD class="xl65" style="border-left: none;" width="70">Ora_inizio</TD><TD class="xl65" style="border-left: none;" width="61">Ora_fine</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:59</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:00</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:01</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:02</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:03</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">b</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:02</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">b</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:04</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR></TBODY></TABLE><P></P><P>Someone could help me.</P><P>Thanks in advance</P></BODY></HTML> Mon, 05 Mar 2018 18:17:13 GMT galileumax 2018-03-05T18:17:13Z Add rows in table between start and enddate for every minute https://community.qlik.com/t5/QlikView/Add-rows-in-table-between-start-and-enddate-for-every-minute/m-p/52035#M8639 <HTML><HEAD></HEAD><BODY><P>Hello to all,</P><P>from a table made like this :</P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 511px;"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="130">StartDate</TD><TD class="xl63" style="border-left: none;" width="130">EndDate</TD><TD class="xl63" style="border-left: none;" width="70">Ora_inizio</TD><TD class="xl63" style="border-left: none;" width="61">Ora_fine</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">a</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl65" style="border-top: none; border-left: none;">09:59</TD><TD class="xl65" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">b</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl65" style="border-top: none; border-left: none;">09:02</TD><TD class="xl65" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">c</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl64" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl65" style="border-top: none; border-left: none;">09:03</TD><TD class="xl65" style="border-top: none; border-left: none;">09:05</TD></TR></TBODY></TABLE><P></P><P>I would like to have a table like that:</P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 455px;"><TBODY><TR><TD class="xl65" height="20" width="64">ID</TD><TD class="xl65" style="border-left: none;" width="130">StartDate</TD><TD class="xl65" style="border-left: none;" width="130">EndDate</TD><TD class="xl65" style="border-left: none;" width="70">Ora_inizio</TD><TD class="xl65" style="border-left: none;" width="61">Ora_fine</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:59</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:00</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:01</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:02</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:03</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:59:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 10:04:53</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD><TD class="xl67" style="border-top: none; border-left: none;">10:04</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">b</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:02</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">b</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:02:23</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:53</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:03</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:04</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">c</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:03:13</TD><TD class="xl66" style="border-top: none; border-left: none;">02/03/2018 09:05:43</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD><TD class="xl67" style="border-top: none; border-left: none;">09:05</TD></TR></TBODY></TABLE><P></P><P>Someone could help me.</P><P>Thanks in advance</P></BODY></HTML> Mon, 05 Mar 2018 18:17:13 GMT https://community.qlik.com/t5/QlikView/Add-rows-in-table-between-start-and-enddate-for-every-minute/m-p/52035#M8639 galileumax 2018-03-05T18:17:13Z