topic Net working hours between DATES in QlikView

Net working hours between DATES

Sun, 22 Mar 2015 05:11:51 GMT

Hi all, i am new to qlikview.

I have a data like ProjectName- start_date and end_date.I want to compare working days between Start_Date and End_Date,also net working hours between these two Dates.

Can any one help me,

Regards,

Sruthi

Re: Net working hours between DATES

arulsettu — Sun, 22 Mar 2015 05:24:43 GMT

try this

=NetWorkDays(Start_date,end_date)

Re: Net working hours between DATES

arulsettu — Sun, 22 Mar 2015 05:28:13 GMT

to find working hours check this

http://community.qlik.com/message/252929#252929

Re: Net working hours between DATES

Sun, 22 Mar 2015 14:06:07 GMT

Hi arul,

Thanks for your reply, if any festivals are there it should be include between these dates

Regards

sruthi