topic Re: date of next row in QlikView

date of next row

Tue, 12 Aug 2014 06:58:54 GMT

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.

Re: date of next row

Tue, 12 Aug 2014 20:06:37 GMT

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

Re: date of next row

MarcoWedel — Tue, 12 Aug 2014 21:11:29 GMT

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

Re: date of next row

jagan — Wed, 13 Aug 2014 03:20:48 GMT

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.

Re: date of next row

MarcoWedel — Sat, 23 Aug 2014 10:27:21 GMT

Please mark as closed if there are no further questions.

thanks

regards

Marco