Working hours field not getting evaluated

tellmalaika17 — Tue, 14 Jun 2016 15:33:43 GMT

I have added below script in the backend and naming it as WorkingHours...This is excluding weekend and calculating hours accordingly.

nterval(
rangesum(
NetWorkDays(DT1+1,DT2-1) * 1
,if(NetWorkDays(DT1,DT11-frac(DT1),0)
,if(NetWorkDays(DT2,DT2), frac(DT2),0)
,if(NetWorkDays(DT1,DT1) and floor(DT1)=floor(DT2),-1 ) )))as 'WorkingHours',

Works well for some dates. Working hours col has been taken as dim just to present the correct nos. These nos should reflect in working hours(expression) column ideally. Using ='WorkingHours' on the straight table as an expression. See below : Would really appreciate, if someone can help me out get the nos correct. Thanks

Working Hours (dimension)	Working Hours(expression)	Value	weighted	final	Correct Hrs
		77000		11:29:07	79:46:39
0:22:30	0:22:30	30000	9:21:02	0:08:46	0.0060877
23:05:30	23:05:30	20000	6:14:02	5:59:52	0.2499098
333:45:42	21:35:42	15000	4:40:31	4:12:25	2.7091044
55:16:46	7:16:46	12000	3:44:25	1:08:04	0.3589574

Re: Working hours field not getting evaluated

prabhu0505 — Tue, 14 Jun 2016 15:51:28 GMT

NetWorkDays function skips weekends by default, look for some other alternative.

topic Re: Working hours field not getting evaluated in QlikView

Working hours field not getting evaluated

Re: Working hours field not getting evaluated