topic Date Diff Issue in QlikView https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604188#M223238 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I got one requirement like I have to find out how many days has taken for completing the one task. it's having starting and ending dates. But while calculating the date differences I should not consider the weekend(Saturday and Sunday) and Govt holidays.</P><P>Kindly suggest on this how can I process.</P><P></P><P>I have to implement the same date diff logic with more than 10 different fileds.</P></BODY></HTML> Wed, 05 Mar 2014 12:55:29 GMT svsudhakar 2014-03-05T12:55:29Z Date Diff Issue https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604188#M223238 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I got one requirement like I have to find out how many days has taken for completing the one task. it's having starting and ending dates. But while calculating the date differences I should not consider the weekend(Saturday and Sunday) and Govt holidays.</P><P>Kindly suggest on this how can I process.</P><P></P><P>I have to implement the same date diff logic with more than 10 different fileds.</P></BODY></HTML> Wed, 05 Mar 2014 12:55:29 GMT https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604188#M223238 svsudhakar 2014-03-05T12:55:29Z Re: Date Diff Issue https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604189#M223239 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use this which will handle weekends:</P><P>NetWorkDays(startdate, enddate) </P><P></P><P>Load holidays into a quoted,comma separated list in a variable (eg vHolidays = '2014/01/01', '2014/03/21') and use to handle all non-working days:</P><P>NetWorkDays(startdate, enddate, $(vHolidays))</P><P></P><P>Or use a working day flag in a master calendar and sum the flag values to get the number of working days.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 05 Mar 2014 13:00:07 GMT https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604189#M223239 jonathandienst 2014-03-05T13:00:07Z Re: Date Diff Issue https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604190#M223240 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file...</P></BODY></HTML> Wed, 05 Mar 2014 13:11:09 GMT https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604190#M223240 MK_QSL 2014-03-05T13:11:09Z Re: Date Diff Issue https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604191#M223241 <HTML><HEAD></HEAD><BODY><P>Thank you this working fine</P></BODY></HTML> Thu, 06 Mar 2014 13:22:19 GMT https://community.qlik.com/t5/QlikView/Date-Diff-Issue/m-p/604191#M223241 svsudhakar 2014-03-06T13:22:19Z