topic Counting working days in QlikView https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149092#M27303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would need to count the amount of working days between certain date range. The issue is that I have a Table A in which there are FromDate and ToDate -fields to determine the date range. Then I have a Table B in which there is a TransDate -field that contains the information about each date whether it is a working day or not. How can I define in the script that I should get a count of working days (Count(TransDate)) between FromDate and ToDate? In addition, in the Table A, there is a AmountMST -field which value I need to divide by the amount of working days. The issue is presented and explained below in more detail:</P><P>Table A:<BR />FromDate<BR />ToDate<BR />AmountMST (this needs to be divided by the amount of working days)<BR />EmplID<BR /><BR />Table C:<BR />EmplID<BR />CalendarID<BR /><BR />Table B:<BR />CalendarID<BR />TransDate (we need to count all the days that are working days between<BR /> any given FromDate and ToDate values)<BR />WorkTimeControl (the value of this field needs to be 0 in order to<BR /> get rid of free days. That way only working days are<BR /> left and we can get their count)<BR /><BR />The issue in more detail is the following:<BR />We have forecasted a certain labor cost (AmountMST) for each employee for a certain date range (FromDate - ToDate). We want to be able to determine a labor cost per day. For that we need to determine the amount<BR />of working days in that date range. We can figure it out by first identifying employee's calendar through Table C. Then in table B, get all the working days for that employee as we set WorkTimeControl to 0. However, I find it difficult to define that we need to have a count of working days from a certain date range. Can anybody help with that?</P><P>Thanks,</P><P>Petteri</P></BODY></HTML> Mon, 13 Jul 2009 02:33:59 GMT 2009-07-13T02:33:59Z Counting working days https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149092#M27303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would need to count the amount of working days between certain date range. The issue is that I have a Table A in which there are FromDate and ToDate -fields to determine the date range. Then I have a Table B in which there is a TransDate -field that contains the information about each date whether it is a working day or not. How can I define in the script that I should get a count of working days (Count(TransDate)) between FromDate and ToDate? In addition, in the Table A, there is a AmountMST -field which value I need to divide by the amount of working days. The issue is presented and explained below in more detail:</P><P>Table A:<BR />FromDate<BR />ToDate<BR />AmountMST (this needs to be divided by the amount of working days)<BR />EmplID<BR /><BR />Table C:<BR />EmplID<BR />CalendarID<BR /><BR />Table B:<BR />CalendarID<BR />TransDate (we need to count all the days that are working days between<BR /> any given FromDate and ToDate values)<BR />WorkTimeControl (the value of this field needs to be 0 in order to<BR /> get rid of free days. That way only working days are<BR /> left and we can get their count)<BR /><BR />The issue in more detail is the following:<BR />We have forecasted a certain labor cost (AmountMST) for each employee for a certain date range (FromDate - ToDate). We want to be able to determine a labor cost per day. For that we need to determine the amount<BR />of working days in that date range. We can figure it out by first identifying employee's calendar through Table C. Then in table B, get all the working days for that employee as we set WorkTimeControl to 0. However, I find it difficult to define that we need to have a count of working days from a certain date range. Can anybody help with that?</P><P>Thanks,</P><P>Petteri</P></BODY></HTML> Mon, 13 Jul 2009 02:33:59 GMT https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149092#M27303 2009-07-13T02:33:59Z Counting working days https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149093#M27304 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I don't really understand your problem but try to use the <STRONG>networkdays</STRONG> formula.</P><P>Regard's</P><P>Amar</P><P></P></BODY></HTML> Mon, 13 Jul 2009 11:24:50 GMT https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149093#M27304 amars 2009-07-13T11:24:50Z Counting working days https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149094#M27305 <HTML><HEAD></HEAD><BODY><P>Use the <STRONG>networkdays()</STRONG> function. Refer to help manual for details.</P><P></P><P>Regards,</P><P>Amit</P></BODY></HTML> Mon, 13 Jul 2009 13:57:38 GMT https://community.qlik.com/t5/QlikView/Counting-working-days/m-p/149094#M27305 2009-07-13T13:57:38Z