topic Next row value in QlikView https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226291#M78498 <HTML><HEAD></HEAD><BODY><P>Hi XXX,</P><P>Try this attached application.</P><P></P></BODY></HTML> Wed, 23 Feb 2011 09:21:02 GMT 2011-02-23T09:21:02Z Next row value https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226289#M78496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is it possible to get this functionality in Qlikview.</P><P>Consider the below table</P><TABLE border="1" cellpadding="3" cellspacing="0" class="parm_values" width="250"><TBODY><TR class="th_left_top"><TH>ORDER_DATE</TH><TH>PRODUCT_ID</TH><TH>QTY</TH></TR><TR><TD>25/09/2007</TD><TD>1000</TD><TD>20</TD></TR><TR><TD>26/09/2007</TD><TD>2000</TD><TD>15</TD></TR><TR><TD>27/09/2007</TD><TD>1000</TD><TD>8</TD></TR><TR><TD>28/09/2007</TD><TD>2000</TD><TD>12</TD></TR><TR><TD>29/09/2007</TD><TD>2000</TD><TD>2</TD></TR><TR><TD>30/09/2007</TD><TD>1000</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>I want the result like this.</P><TABLE border="1" cellpadding="3" cellspacing="0" class="parm_values" width="350"><TBODY><TR class="th_left_top"><TH>PRODUCT_ID</TH><TH>ORDER_DATE</TH><TH>NEXT_ORDER_DATE</TH></TR><TR><TD>1000</TD><TD>25/09/2007</TD><TD>26/09/2007</TD></TR><TR><TD>2000</TD><TD>26/09/2007</TD><TD>27/09/2007</TD></TR><TR><TD>1000</TD><TD>27/09/2007</TD><TD>28/09/2007</TD></TR><TR><TD>2000</TD><TD>28/09/2007</TD><TD>29/09/2007</TD></TR><TR><TD>2000</TD><TD>29/09/2007</TD><TD>30/09/2007</TD></TR><TR><TD>1000</TD><TD>30/09/2007</TD><TD>&lt;NULL&gt;</TD></TR></TBODY></TABLE><P></P><P>We can get this done using the lead Function in Oracle. Is there any Similar way we can do this Qlikview.</P></BODY></HTML> Wed, 23 Feb 2011 07:50:08 GMT https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226289#M78496 2011-02-23T07:50:08Z Next row value https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226290#M78497 <HTML><HEAD></HEAD><BODY><P>hi XXX,</P><P>whats you good name ? I hope the attach appliction helps.</P><P></P><P></P><P></P></BODY></HTML> Wed, 23 Feb 2011 08:45:22 GMT https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226290#M78497 deepakk 2011-02-23T08:45:22Z Next row value https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226291#M78498 <HTML><HEAD></HEAD><BODY><P>Hi XXX,</P><P>Try this attached application.</P><P></P></BODY></HTML> Wed, 23 Feb 2011 09:21:02 GMT https://community.qlik.com/t5/QlikView/Next-row-value/m-p/226291#M78498 2011-02-23T09:21:02Z