topic Re: Overnight calculation in QlikView

Overnight calculation

mato32188 — Mon, 07 Apr 2014 06:45:24 GMT

Hi QV fans,

if anyone knows how to use "?" to calculate records like:

Cell	Start	Finish	Start Time	Finish Time	NewDay	@NewDay	Stoppage
Cell 1	2013/08/20 23:45:08	2013/08/20 23:49:28	20.8.2013	20.8.2013	20.8.2013	0	0,38
Cell 1	2013/08/20 23:50:44	2013/08/20 23:55:05	20.8.2013	20.8.2013	20.8.2013	0	1,27
Cell 1	2013/08/21 00:21:22	2013/08/21 00:25:08	21.8.2013	21.8.2013	20.8.2013	1	26,28

Stoppage [min] is calculated as difference between last Finish and next Start. Could anybody help, how to calculate Stoppage till 23:59:59 and rest of stoppage time add to next record?...Thanks a lot

Martin

Re: Overnight calculation

tresB — Mon, 07 Apr 2014 07:05:18 GMT

Could you elaborate a bit more(would be better if with an expected output example)?

Re: Overnight calculation

mato32188 — Mon, 07 Apr 2014 07:19:14 GMT

Cell	Start	Finish	Start Time	Finish Time	NewDay	@NewDay	Expected Stoppage [min]
Cell 1	2013/08/20 23:45:08	2013/08/20 23:49:28	20.8.2013	20.8.2013	20.8.2013	0	X
Cell 1	2013/08/20 23:50:44	2013/08/20 23:55:05	20.8.2013	20.8.2013	20.8.2013	0	(20.8.2013 23:59:59-20.8.2013 23:55:05)
Cell 1	2013/08/21 00:21:22	2013/08/21 00:25:08	21.8.2013	21.8.2013	20.8.2013	1	21.8.2013 00:21:21 - 20.8.2013 00:00:00)

Re: Overnight calculation

arjunkrishnan — Mon, 07 Apr 2014 07:21:17 GMT

Hellow Frd See This Sample Qvw.File ...

I Try This One...I hope u to Useful for U..

My Result Like That

Thank U By

Arjun Krish

Re: Overnight calculation

tresB — Mon, 07 Apr 2014 07:35:02 GMT

Do you mean, for the first record, you would want the start timestamp to consider as ...23:59:59 and rest are as it is?

Re: Overnight calculation

mato32188 — Mon, 07 Apr 2014 07:55:05 GMT

I mean, if the stoppage goes thru the midnight, add aliquot stoppage time till the end of day (to 23:59:59) and if there is a rest of stoppage time, add it to next record.

Thanks