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.
