topic Finding minimum during load in QlikView https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091229#M362966 <HTML><HEAD></HEAD><BODY><P>I would like to find the minimum and maximum values of a field during the load process and store those values in variables.&nbsp; Just putting LET vMin=Min(field); in the script doesn't work.&nbsp; Any suggestions?</P><P></P><P><STRONG><EM style="color: #006233; font-family: 'Arial','sans-serif';">Daniel W. Farrow, IV</EM></STRONG></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: gray;">Business Systems Analyst</SPAN></P></BODY></HTML> Fri, 06 May 2016 19:24:01 GMT dwfiv327 2016-05-06T19:24:01Z Finding minimum during load https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091229#M362966 <HTML><HEAD></HEAD><BODY><P>I would like to find the minimum and maximum values of a field during the load process and store those values in variables.&nbsp; Just putting LET vMin=Min(field); in the script doesn't work.&nbsp; Any suggestions?</P><P></P><P><STRONG><EM style="color: #006233; font-family: 'Arial','sans-serif';">Daniel W. Farrow, IV</EM></STRONG></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: gray;">Business Systems Analyst</SPAN></P></BODY></HTML> Fri, 06 May 2016 19:24:01 GMT https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091229#M362966 dwfiv327 2016-05-06T19:24:01Z Re: Finding minimum during load https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091230#M362967 <HTML><HEAD></HEAD><BODY><P>Check the master calendar script where we calculate min and max of date to create the calendar</P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A>‌</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123790_Capture.PNG" style="height: auto;" /></P><P></P><P>Thing to note here is that you can't directly save min and max to a variable. You will have to do a resident load where you calculate min and max and then use Peek to save them in variable.</P></BODY></HTML> Fri, 06 May 2016 20:09:26 GMT https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091230#M362967 sunny_talwar 2016-05-06T20:09:26Z Re: Finding minimum during load https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091231#M362968 <HTML><HEAD></HEAD><BODY><P>Thanks.&nbsp; This worked perfectly!</P></BODY></HTML> Mon, 09 May 2016 12:02:12 GMT https://community.qlik.com/t5/QlikView/Finding-minimum-during-load/m-p/1091231#M362968 dwfiv327 2016-05-09T12:02:12Z