topic Re: Avg working days?? in QlikView https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359244#M416818 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum(Sale)/NetWorkDays(Min(Date), Max(Date), $(=Concat(DISTINCT {&lt;Holiday = {'*'}&gt;} Chr(39) &amp; Date &amp; Chr(39), ', ')))</STRONG></P></BODY></HTML> Mon, 10 Jul 2017 19:00:10 GMT sunny_talwar 2017-07-10T19:00:10Z Avg working days?? https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359241#M416815 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have a requirement where I need to calculate the avg. sales for given working days which excludes weekend and holidays.</P><P>Please find attached file which explains my requirement.</P><P></P><P>Can anyone please help me?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Jul 2017 18:49:28 GMT https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359241#M416815 qlikuser222 2017-07-10T18:49:28Z Re: Avg working days?? https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359242#M416816 <HTML><HEAD></HEAD><BODY><P>Isn't 12th a Sunday and should not be counted also? Or do we only exclude dates which are in Holidays table?</P></BODY></HTML> Mon, 10 Jul 2017 18:54:57 GMT https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359242#M416816 sunny_talwar 2017-07-10T18:54:57Z Re: Avg working days?? https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359243#M416817 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for reply.</P><P></P><P>Weekends and also dates in Holiday table to be excluded.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Jul 2017 18:56:50 GMT https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359243#M416817 qlikuser222 2017-07-10T18:56:50Z Re: Avg working days?? https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359244#M416818 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Sum(Sale)/NetWorkDays(Min(Date), Max(Date), $(=Concat(DISTINCT {&lt;Holiday = {'*'}&gt;} Chr(39) &amp; Date &amp; Chr(39), ', ')))</STRONG></P></BODY></HTML> Mon, 10 Jul 2017 19:00:10 GMT https://community.qlik.com/t5/QlikView/Avg-working-days/m-p/1359244#M416818 sunny_talwar 2017-07-10T19:00:10Z