Calculate Age based on next records data

Anonymous — Wed, 14 Sep 2016 09:52:34 GMT

Hi,

I have data as below. A Ticket flows into different Departments,and have to calculate the Age of Ticket in each Department.(Cumulative)

A department can be reassigned after moving from a different one.In that case we need calculate cumulatively.

ID	Ticket	Date	Department
33425	001	2016-08-09	A
33437	001	2016-08-09	A
33439	001	2016-08-09	A
33557	001	2016-08-29	G
33563	001	2016-08-29	G
33795	001	2016-08-31	G
33802	001	2016-09-02	A
35094	001	2016-09-02	A
35097	001	2016-09-03	A

So here, the output should be as

For Department A :

ID - 33425 to ID - 33439

(2016- 08- 29 ) to (2016-08-09) = Difference is 0

ID - 33802 to ID- 35097

(2016-09-02) to (2016-09-03) = Difference is 1

So Total Age in Department A is 0+1 = 1.

Where as Calculation for Dept G should be as below.

Ticket went to Dept G on 2016-08-29 and moved to Dept A only on 2016-09-02, which mean Ticket was being handled by Dept G until 2016- 09- 02.

So here the Age should be calculated from

2016 -08-29 (ID , 33557) to 2016-09-02 (ID,33802). - 4

Request you to help on this.

Thanks,

topic Calculate Age based on next records data in QlikView