topic create a column based on dates from different rows in QlikView https://community.qlik.com/t5/QlikView/create-a-column-based-on-dates-from-different-rows/m-p/301165#M1199328 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>Any ideas on how to make a table based on a criteria (end date (row 1) - start date(row 2)) for when "consecutive" dates belongs to a the new period. The periods belongs to a certain person.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="347"><COL style="width: 48pt;" width="64" /><COL span="3" style="width: 55pt;" width="73" /><COL style="width: 48pt;" width="64" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">Person</TD><TD style="width: 55pt;" width="73">Start_date</TD><TD style="width: 55pt;" width="73">End_date</TD><TD style="width: 55pt;" width="73">Period</TD><TD style="width: 48pt;" width="64"></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-01</TD><TD align="right" class="xl65">2010-01-02</TD><TD align="right">1</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-03</TD><TD align="right" class="xl65">2010-01-04</TD><TD align="right">2</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right">3</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Person</TD><TD>Person</TD><TD>Start_date</TD><TD>Old period</TD><TD>Period</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-01</TD><TD align="right" class="xl65">2010-01-02</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-03</TD><TD align="right" class="xl65">2010-01-04</TD><TD align="right">2</TD><TD align="right">1</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right">3</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Kind Regards,</P><P>Markus</P></BODY></HTML> Tue, 25 Jan 2011 13:51:06 GMT 2011-01-25T13:51:06Z create a column based on dates from different rows https://community.qlik.com/t5/QlikView/create-a-column-based-on-dates-from-different-rows/m-p/301165#M1199328 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>Any ideas on how to make a table based on a criteria (end date (row 1) - start date(row 2)) for when "consecutive" dates belongs to a the new period. The periods belongs to a certain person.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="347"><COL style="width: 48pt;" width="64" /><COL span="3" style="width: 55pt;" width="73" /><COL style="width: 48pt;" width="64" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">Person</TD><TD style="width: 55pt;" width="73">Start_date</TD><TD style="width: 55pt;" width="73">End_date</TD><TD style="width: 55pt;" width="73">Period</TD><TD style="width: 48pt;" width="64"></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-01</TD><TD align="right" class="xl65">2010-01-02</TD><TD align="right">1</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-03</TD><TD align="right" class="xl65">2010-01-04</TD><TD align="right">2</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right">3</TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Person</TD><TD>Person</TD><TD>Start_date</TD><TD>Old period</TD><TD>Period</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-01</TD><TD align="right" class="xl65">2010-01-02</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-03</TD><TD align="right" class="xl65">2010-01-04</TD><TD align="right">2</TD><TD align="right">1</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">A</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right" class="xl65">2010-01-10</TD><TD align="right">3</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Kind Regards,</P><P>Markus</P></BODY></HTML> Tue, 25 Jan 2011 13:51:06 GMT https://community.qlik.com/t5/QlikView/create-a-column-based-on-dates-from-different-rows/m-p/301165#M1199328 2011-01-25T13:51:06Z