topic Re: Get the average of time using Interval in Load Script in QlikView https://community.qlik.com/t5/QlikView/Get-the-average-of-time-using-Interval-in-Load-Script/m-p/731555#M262020 <HTML><HEAD></HEAD><BODY><P>aggr() is not valid in script. The logical equivalent in script would be GROUP BY.</P><P></P><P>-Rob</P></BODY></HTML> Mon, 23 Jun 2014 18:26:14 GMT rwunderlich 2014-06-23T18:26:14Z Get the average of time using Interval in Load Script https://community.qlik.com/t5/QlikView/Get-the-average-of-time-using-Interval-in-Load-Script/m-p/731554#M262019 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>How can I get the below code to work in the load script. Aggr gives me an error</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AVG</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[COR DATE]</SPAN><SPAN style="font-size: 8pt;"> - </SPAN><SPAN style="color: #800000; font-size: 8pt;">[CO DATE]</SPAN><SPAN style="font-size: 8pt;"> ,</SPAN><SPAN style="color: #800000; font-size: 8pt;">TRACE_NUMBER</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">TRACE_NUMBER</SPAN><SPAN style="font-size: 8pt;">)),'dd hh:mm:ss')<BR /><BR /> Your soonest response will be highly appreciated</SPAN></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Mpho</SPAN></P></BODY></HTML> Mon, 23 Jun 2014 18:10:51 GMT https://community.qlik.com/t5/QlikView/Get-the-average-of-time-using-Interval-in-Load-Script/m-p/731554#M262019 2014-06-23T18:10:51Z Re: Get the average of time using Interval in Load Script https://community.qlik.com/t5/QlikView/Get-the-average-of-time-using-Interval-in-Load-Script/m-p/731555#M262020 <HTML><HEAD></HEAD><BODY><P>aggr() is not valid in script. The logical equivalent in script would be GROUP BY.</P><P></P><P>-Rob</P></BODY></HTML> Mon, 23 Jun 2014 18:26:14 GMT https://community.qlik.com/t5/QlikView/Get-the-average-of-time-using-Interval-in-Load-Script/m-p/731555#M262020 rwunderlich 2014-06-23T18:26:14Z