Next row value

[#1]

Hi,

Is it possible to get this functionality in Qlikview.

Consider the below table

ORDER_DATE	PRODUCT_ID	QTY
25/09/2007	1000	20
26/09/2007	2000	15
27/09/2007	1000	8
28/09/2007	2000	12
29/09/2007	2000	2
30/09/2007	1000	4

I want the result like this.

PRODUCT_ID	ORDER_DATE	NEXT_ORDER_DATE
1000	25/09/2007	26/09/2007
2000	26/09/2007	27/09/2007
1000	27/09/2007	28/09/2007
2000	28/09/2007	29/09/2007
2000	29/09/2007	30/09/2007
1000	30/09/2007	<NULL>

We can get this done using the lead Function in Oracle. Is there any Similar way we can do this Qlikview.

[deepakk]

hi XXX,

whats you good name ? I hope the attach appliction helps.

[#3]

Hi XXX,

Try this attached application.