Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date of next row

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.

4 Replies
Not applicable
Author

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

MarcoWedel

Hi,

one solution:

QlikCommunity_Thread_129123_Pic1.JPG.jpg

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
Luminary Alumni
Luminary Alumni

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