topic Create time line based on following data? in QlikView

topic Create time line based on following data? in QlikView https://community.qlik.com/t5/QlikView/Create-time-line-based-on-following-data/m-p/844304#M296535 <HTML><HEAD></HEAD><BODY><P>Dear Experts</P><P></P><P>Help me to create the time line based on below data Act_type and Receiver should be milestone on the timeline for equnr.</P><P></P><P></P><P>Thanks in advance</P><P></P><P>Ashif Tadvi</P><P></P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 260px;"><TBODY><TR><TD class="xl63" height="17" width="72">equnr</TD><TD class="xl63" style="border-left: none;" width="60">Act_Typ</TD><TD class="xl63" style="border-left: none;" width="66">Receiver</TD><TD class="xl63" style="border-left: none;" width="62">Doc_Date</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/02/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">E</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/02/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">13/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">13/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/07/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">I</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">29/07/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">R</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">04/12/2012</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">04/12/2012</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">E</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">26/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">27/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">27/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30/12/2013</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Apr 2015 06:09:36 GMT 2015-04-16T06:09:36Z Create time line based on following data? https://community.qlik.com/t5/QlikView/Create-time-line-based-on-following-data/m-p/844304#M296535 <HTML><HEAD></HEAD><BODY><P>Dear Experts</P><P></P><P>Help me to create the time line based on below data Act_type and Receiver should be milestone on the timeline for equnr.</P><P></P><P></P><P>Thanks in advance</P><P></P><P>Ashif Tadvi</P><P></P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 260px;"><TBODY><TR><TD class="xl63" height="17" width="72">equnr</TD><TD class="xl63" style="border-left: none;" width="60">Act_Typ</TD><TD class="xl63" style="border-left: none;" width="66">Receiver</TD><TD class="xl63" style="border-left: none;" width="62">Doc_Date</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/02/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">E</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/02/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">13/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">13/06/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/07/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">I</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">29/07/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">R</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/12/2011</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1674</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">04/12/2012</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">04/12/2012</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">E</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/01/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">F</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">26/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1119</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">27/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">27/08/2013</TD></TR><TR><TD align="right" class="xl66" height="17" style="border-top: none;">8963</TD><TD class="xl64" style="border-top: none; border-left: none;">ER</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8527</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30/12/2013</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Apr 2015 06:09:36 GMT https://community.qlik.com/t5/QlikView/Create-time-line-based-on-following-data/m-p/844304#M296535 2015-04-16T06:09:36Z