topic Re: Network Days in Script: Error in QlikView https://community.qlik.com/t5/QlikView/Network-Days-in-Script-Error/m-p/982833#M949638 <HTML><HEAD></HEAD><BODY><P>Min/Max are aggregations which requires an aggreagtion-load with group by.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 09 Dec 2015 15:26:06 GMT marcus_sommer 2015-12-09T15:26:06Z Network Days in Script: Error https://community.qlik.com/t5/QlikView/Network-Days-in-Script-Error/m-p/982832#M949637 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi,</SPAN></P><P></P><P><SPAN style="color: #000000;">I tried to create this in my script:</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">NetworkDays</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #0000ff;">Min</SPAN>(<SPAN style="color: #800000;">Date</SPAN>),<SPAN style="color: #0000ff;">Max</SPAN>(<SPAN style="color: #800000;">Date</SPAN>)) <SPAN style="color: #0000ff;">as</SPAN> </SPAN><SPAN style="color: #800000; font-size: 12pt;">BusDays</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">but it won't work.</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">I need BusDays field to be able to divide Sales/BusDays, since date isn't working days.</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">And I want this on a monthly basis, so that each month busdays amount will change.</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">How do I set this up? in my script or in the dashboard?</SPAN></P></BODY></HTML> Wed, 09 Dec 2015 15:14:39 GMT https://community.qlik.com/t5/QlikView/Network-Days-in-Script-Error/m-p/982832#M949637 stjernvd 2015-12-09T15:14:39Z Re: Network Days in Script: Error https://community.qlik.com/t5/QlikView/Network-Days-in-Script-Error/m-p/982833#M949638 <HTML><HEAD></HEAD><BODY><P>Min/Max are aggregations which requires an aggreagtion-load with group by.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 09 Dec 2015 15:26:06 GMT https://community.qlik.com/t5/QlikView/Network-Days-in-Script-Error/m-p/982833#M949638 marcus_sommer 2015-12-09T15:26:06Z