topic Duration in QlikView https://community.qlik.com/t5/QlikView/Duration/m-p/343907#M126987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; I want to calculate the number of working days for each individual employee. </P><P></P><P>&nbsp;&nbsp;&nbsp; I have the Table Emp</P><P></P><P>&nbsp;&nbsp;&nbsp; EMPID&nbsp;&nbsp; STARTDATE&nbsp;&nbsp;&nbsp;&nbsp; ENDDATE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/31/9999</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2010</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/20/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/30/2011</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2012</P><P></P><P></P><P>I understand we can use networkdays to calculate the number of Working Days by excluding the Saturday,Sunday and Holidays. But it will give me 180 days. However&nbsp; i want the number of working days per Emp on monthwise</P><P>I need the result like </P><P></P><P>EMPID&nbsp;&nbsp;&nbsp;&nbsp; NoofWorkingDays&nbsp; Month&nbsp;&nbsp;&nbsp; Year</P><P> 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAY&nbsp;&nbsp;&nbsp;&nbsp; 2010</P><P> 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010</P></BODY></HTML> Tue, 10 Jul 2012 21:00:09 GMT brindlogcool 2012-07-10T21:00:09Z Duration https://community.qlik.com/t5/QlikView/Duration/m-p/343907#M126987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; I want to calculate the number of working days for each individual employee. </P><P></P><P>&nbsp;&nbsp;&nbsp; I have the Table Emp</P><P></P><P>&nbsp;&nbsp;&nbsp; EMPID&nbsp;&nbsp; STARTDATE&nbsp;&nbsp;&nbsp;&nbsp; ENDDATE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/31/9999</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2010</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/20/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/30/2011</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/02/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/15/2012</P><P></P><P></P><P>I understand we can use networkdays to calculate the number of Working Days by excluding the Saturday,Sunday and Holidays. But it will give me 180 days. However&nbsp; i want the number of working days per Emp on monthwise</P><P>I need the result like </P><P></P><P>EMPID&nbsp;&nbsp;&nbsp;&nbsp; NoofWorkingDays&nbsp; Month&nbsp;&nbsp;&nbsp; Year</P><P> 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAY&nbsp;&nbsp;&nbsp;&nbsp; 2010</P><P> 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010</P></BODY></HTML> Tue, 10 Jul 2012 21:00:09 GMT https://community.qlik.com/t5/QlikView/Duration/m-p/343907#M126987 brindlogcool 2012-07-10T21:00:09Z