topic Re: Need help in optimization in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266747#M398994 <HTML><HEAD></HEAD><BODY><P>Yeah, it works perfectly. Thanks for the reference</P></BODY></HTML> Thu, 01 Dec 2016 19:42:54 GMT Anonymous 2016-12-01T19:42:54Z Need help in optimization https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266745#M398992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with 6,778,904 records and from that i need to take the maximum and minimum date. I used the following code. But it is taking more time to complete.</P><P></P><P>CalTemp:</P><P>LOAD</P><P>max(SERVICEDATE) as MaxDate,</P><P>min(SERVICEDATE) as MinDate</P><P>Resident COST;</P><P></P><P>I am loading the COST from a qvd file. Any idea on how to optimize this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 01 Dec 2016 19:11:40 GMT https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266745#M398992 Anonymous 2016-12-01T19:11:40Z Re: Need help in optimization https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266746#M398993 <HTML><HEAD></HEAD><BODY><P>Just what you need:</P><P><A href="http://qlikviewcookbook.com/2015/05/better-calendar-scripts/" title="http://qlikviewcookbook.com/2015/05/better-calendar-scripts/">Better Calendar Scripts | Qlikview Cookbook</A></P></BODY></HTML> Thu, 01 Dec 2016 19:12:57 GMT https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266746#M398993 sunny_talwar 2016-12-01T19:12:57Z Re: Need help in optimization https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266747#M398994 <HTML><HEAD></HEAD><BODY><P>Yeah, it works perfectly. Thanks for the reference</P></BODY></HTML> Thu, 01 Dec 2016 19:42:54 GMT https://community.qlik.com/t5/QlikView/Need-help-in-optimization/m-p/1266747#M398994 Anonymous 2016-12-01T19:42:54Z