# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## time passed between 2 dates by Customer ID

Hello,

i want to calculate in script, by every Order ID of the following 3 customers the time difference (in days) from their previous order.

In case of their first order, the Diff should be 0.

for ex, for Customer ID 1, his second order (22.02) will have on the desired calculated column 5, because his first order was 5 days ago (17.02).

P.S. i don't have the table sorted like in this example.

 Customer ID Order ID Order Date Diff 1 2 2/17/2020 0 1 3 2/22/2020 5 1 10 5/18/2020 86 2 5 3/30/2020 0 2 6 4/20/2020 21 3 1 1/2/2020 0 3 4 3/16/2020 74 3 7 5/7/2020 52 3 8 5/16/2020 9 3 9 5/17/2020 1
1 Solution

Accepted Solutions

One solution is.

``````tab1:
LOAD *, If([Customer ID]=Previous([Customer ID]),[Order Date]-Peek([Order Date]),0) As Diff;
Customer ID, Order ID, Order Date
1, 2, 2/17/2020
1, 3, 2/22/2020
1, 10, 5/18/2020
2, 5, 3/30/2020
2, 6, 4/20/2020
3, 1, 1/2/2020
3, 4, 3/16/2020
3, 7, 5/7/2020
3, 8, 5/16/2020
3, 9, 5/17/2020
];``````
2 Replies

One solution is.

``````tab1:
LOAD *, If([Customer ID]=Previous([Customer ID]),[Order Date]-Peek([Order Date]),0) As Diff;
Customer ID, Order ID, Order Date
1, 2, 2/17/2020
1, 3, 2/22/2020
1, 10, 5/18/2020
2, 5, 3/30/2020
2, 6, 4/20/2020
3, 1, 1/2/2020
3, 4, 3/16/2020
3, 7, 5/7/2020
3, 8, 5/16/2020
3, 9, 5/17/2020
];``````

Community Browser