How to get the next value of column.

[#1]

hi,

i have two  column as time and defect id.The defect id has different time and date.i need to show the start date and end date of defect id.

if there are different defect id for each defect id i need to calculate the start and end date

defect id    time

1              014-05-26 22:41:34

2              2014-05-28 05:59:11

1              2014-05-30 02:37:04

2              2014-05-26 00:07:52

1             2014-05-26 15:37:14

2              2014-05-26 22:41:34

3              2014-05-28 05:59:11

3             2014-05-30 02:37:04

etc

i need is:

defect id    time                                          start date                                end date

1              014-05-26 22:41:34                      014-05-26 22:41:34                  2014-05-30 02:37:04

2              2014-05-28 05:59:11                    2014-05-28 05:59:11                 2014-05-26 00:07:52

1              2014-05-30 02:37:04                    2014-05-30 02:37:04                  2014-05-26 15:37:14

2              2014-05-26 00:07:52                   2014-05-26 00:07:52                   2014-05-26 22:41:34

1             2014-05-26 15:37:14                    2014-05-26 15:37:14                   todays date

2              2014-05-26 22:41:34                   2014-05-26 22:41:34                     today date

3              2014-05-28 05:59:11                  2014-05-28 05:59:11                       2014-05-30 02:37:04

3             2014-05-30 02:37:04                  2014-05-30 02:37:04                       today date

if i will put filter on defect id say 1 is selected then it will show :

defect id          time                                    startdate                                   end date                  

1                     014-05-26 22:41:34                014-05-26 22:41:34                 2014-05-30 02:37:04

1                     2014-05-30 02:37:04              2014-05-30 02:37:04                2014-05-26 15:37:14

1                     2014-05-26 15:37:14                  2014-05-26 15:37:14              todays date

[#2]

[MK_QSL]

Change only one line

IF([defect id] = Previous([defect id]),Previous(time),Date(Today())) as EndDate,

[#4]

[MK_QSL · Accepted solution]

  IF([defect id] = Previous([defect id]),Previous(time),Date(Today(),'YYYY-MM-DD') as EndDate,

[#6]

no still it i not coming correct

[MK_QSL]

Let me have your QVW file please..

[#8]

hi please find the attached qvw file .

[MK_QSL]

QVW file please !

[#10]

i have already shared the qvw file please check first discussion page

[#11]

hi manish,

  did you get the qvw file?