Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
From Below Screen Shot we can Find( billing Date ,Vessel Date,Billing time,Vessel Time,Month) . from these fields need to calculate the following
Output:
for Example 2 Row:
Billing Date Time 08-09-2017 09:00:04 AM and Vessel Date time 11-09-2017 11:00:03 AM
Working Hours required to fill the vessel is 10 hours because as we have remove dates of 09 sep and 10 Sep 2017 as they are weekends and non working hours.
Regards,
Bharath.B
Hi Jagan,
thanks for the reply.
But can u please explain the same with above example
Hi Bharat,
Go through those links it has very clear cut examples with good description.
Regards,
Jagan.
HI Jagan,
This Code is Working perfectly only for Working hours from 9 and 18 hours.
can u plz suggest me values to define values for morning 9.00 AM and Evening 17.30 PM
Because if i define variable values with 09 and 17.30 its not Working.
Can u please Help me out
Hi,
Change this variables
https://community.qlik.com/servlet/JiveServlet/showImage/102-16489-2-122518/pastedImage_20.png
Regards,
Jagan.
Hi Jagan,
I clearly Agree with your point. but here iam asking about morning 9.30 and evening 17.30
this coding is not working for Let vstarthour=9.30
let Vendhour=17.30
Hi Jagan,
I clearly Agree with your point. but here iam asking about morning 9.30 and evening 17.30
this coding is not working for Let vstarthour=9.30
let Vendhour=17.30