topic Re: How to calculate top n minimum date in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893248#M1007277 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">renewalbase,3) as ThirdLargestValue</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">FROM ...</SPAN></P></BODY></HTML> Thu, 07 May 2015 09:45:57 GMT Gysbert_Wassenaar 2015-05-07T09:45:57Z How to calculate top n minimum date https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893247#M1007276 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">select min(renewalbase) from (select DISTINCT top 3 [renewalbase] from STP_LMS_Lead (NoLock) order by renewalbase desc) a)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">how i can achive the above sql code in qlikview&nbsp; [ RenewalBase is date field ]</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Sarfaraz<BR /></SPAN></P></BODY></HTML> Thu, 07 May 2015 09:23:38 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893247#M1007276 sarfaraz_sheikh 2015-05-07T09:23:38Z Re: How to calculate top n minimum date https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893248#M1007277 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">renewalbase,3) as ThirdLargestValue</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">FROM ...</SPAN></P></BODY></HTML> Thu, 07 May 2015 09:45:57 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893248#M1007277 Gysbert_Wassenaar 2015-05-07T09:45:57Z Re: How to calculate top n minimum date https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893249#M1007278 <HTML><HEAD></HEAD><BODY><P>Dear Gysbert,</P><P></P><P>Thanks for your solution ...it is working as expected brilliant..</P><P></P><P>Sarfaraz</P></BODY></HTML> Fri, 08 May 2015 05:51:42 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-top-n-minimum-date/m-p/893249#M1007278 sarfaraz_sheikh 2015-05-08T05:51:42Z