Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi XXX,
whats you good name ? I hope the attach appliction helps.
Hi XXX,
Try this attached application.