topic Net work Days in current month in QlikView https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151639#M376230 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi Guys</SPAN></P><P></P><P><SPAN style="color: #000000;">I want to count average sales per day. <SPAN style="font-size: 10pt; line-height: 1.5em;">I am counting total sales for the current month by using following expression.</SPAN></SPAN></P><P></P><P><SPAN style="font-family: 'courier new', courier; color: #000000;">=<SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN>(<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #993300;">[Completion Date]</SPAN>) = <SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>()), <SPAN style="color: #993300;">OrderId</SPAN>)))</SPAN></P><P></P><P><SPAN style="color: #000000;"><STRONG>How to get number of total working days in present month? </STRONG>to divide with above expression</SPAN></P><P></P><P><SPAN style="color: #000000;">Thanks</SPAN></P></BODY></HTML> Tue, 23 Aug 2016 00:59:32 GMT 2016-08-23T00:59:32Z Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151639#M376230 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi Guys</SPAN></P><P></P><P><SPAN style="color: #000000;">I want to count average sales per day. <SPAN style="font-size: 10pt; line-height: 1.5em;">I am counting total sales for the current month by using following expression.</SPAN></SPAN></P><P></P><P><SPAN style="font-family: 'courier new', courier; color: #000000;">=<SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN>(<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #993300;">[Completion Date]</SPAN>) = <SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>()), <SPAN style="color: #993300;">OrderId</SPAN>)))</SPAN></P><P></P><P><SPAN style="color: #000000;"><STRONG>How to get number of total working days in present month? </STRONG>to divide with above expression</SPAN></P><P></P><P><SPAN style="color: #000000;">Thanks</SPAN></P></BODY></HTML> Tue, 23 Aug 2016 00:59:32 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151639#M376230 2016-08-23T00:59:32Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151640#M376231 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>NetWorkDays(Floor(MonthStart(Today())), Floor(MonthEnd(Today())))</STRONG></P></BODY></HTML> Tue, 23 Aug 2016 01:18:28 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151640#M376231 sunny_talwar 2016-08-23T01:18:28Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151641#M376232 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny...</P><P></P><P>Your expression is giving me total as 23</P><P></P><P>how do I exclude weekends?</P><P></P><P>thanks</P></BODY></HTML> Tue, 23 Aug 2016 01:25:27 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151641#M376232 2016-08-23T01:25:27Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151642#M376233 <HTML><HEAD></HEAD><BODY><P>I think weekends are already excluded here</P></BODY></HTML> Tue, 23 Aug 2016 01:26:37 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151642#M376233 sunny_talwar 2016-08-23T01:26:37Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151643#M376234 <HTML><HEAD></HEAD><BODY><P>I see 23 weekdays in the month of August</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135214_Capture.PNG" style="height: auto;" /> !</P></BODY></HTML> Tue, 23 Aug 2016 01:29:49 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151643#M376234 sunny_talwar 2016-08-23T01:29:49Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151644#M376235 <HTML><HEAD></HEAD><BODY><P>Because today is 23 August and if you subtract 6 weekends then it should give you total as 17 !</P></BODY></HTML> Tue, 23 Aug 2016 01:30:00 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151644#M376235 2016-08-23T01:30:00Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151645#M376236 <HTML><HEAD></HEAD><BODY><P>oh now i got your point lol... i wanted MTD weekedays </P><P></P><P>sorry for confusion</P></BODY></HTML> Tue, 23 Aug 2016 01:33:08 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151645#M376236 2016-08-23T01:33:08Z Re: Net work Days in current month https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151646#M376237 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">NetWorkDays(Floor(MonthStart(Today())), Today())</STRONG></P></BODY></HTML> Tue, 23 Aug 2016 01:43:34 GMT https://community.qlik.com/t5/QlikView/Net-work-Days-in-current-month/m-p/1151646#M376237 sunny_talwar 2016-08-23T01:43:34Z