date of next row

[#1]

Hi All,

I am developing MTTR-MTBF report in that i want to calculate next date and time of order no.

For Ex:  I am having Work Center suppose A and function location P for that work center and function loc having 4 order no. in nov. month. So I am having one order no. having output as next date.

Please find an attachment, in that i want output col. in script side.

[#2]

I'm sorry, could you please try to explain again what you are looking for?

[MarcoWedel]

Hi,

one solution:

table1:
LOAD [Work Center],
     [Functional Location Code],
     [Order NO],
     Timestamp#([Notification Date], 'MM/DD/YYYY hh:mm:ss') as [Notification Date]
FROM [http://community.qlik.com/servlet/JiveServlet/download/586781-119747/Sample.xls]
(biff, embedded labels, table is Sheet1$);

Left Join (table1)

LOAD Distinct
  [Notification Date],
  Previous([Notification Date]) as [next Notification Date]
Resident table1
Order By [Order NO] desc;

hope this helps

regards

Marco

[jagan]

Hi,

Try this script

Data: 

LOAD [Work Center], 

     [Functional Location Code], 

     [Order NO], 

     Timestamp#([Notification Date], 'MM/DD/YYYY hh:mm:ss') as [Notification Date] 

FROM DataSource; 

Left Join (Data)

LOAD

[Work Center],

  [Functional Location Code],

  [Notification Date], 

  Previous([Notification Date]) as [Next Notification Date] 

LOAD Distinct 

   *

Resident Data 

Order By [Order NO] desc;

Hope this helps you.

Regards,

Jagan.

[MarcoWedel]

Please mark as closed if there are no further questions.

thanks

regards

Marco