topic Re: How do i calculate Closing rate? in QlikView https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460491#M171920 <HTML><HEAD></HEAD><BODY><P>You can probaly use the firstsortedvalue function. See <A href="http://qlikshare.com/392">here</A> for a video tutorial.</P></BODY></HTML> Fri, 21 Dec 2012 12:37:47 GMT Gysbert_Wassenaar 2012-12-21T12:37:47Z How do i calculate Closing rate? https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460490#M171919 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if i select company, year &amp; item&nbsp; in that item we should take max ord_no and corresponding that ord_no-"rate" we need to consider as "Closing Rate".</P><P></P><P>Thanks,</P><P>Ashok.</P></BODY></HTML> Fri, 21 Dec 2012 12:13:45 GMT https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460490#M171919 2012-12-21T12:13:45Z Re: How do i calculate Closing rate? https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460491#M171920 <HTML><HEAD></HEAD><BODY><P>You can probaly use the firstsortedvalue function. See <A href="http://qlikshare.com/392">here</A> for a video tutorial.</P></BODY></HTML> Fri, 21 Dec 2012 12:37:47 GMT https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460491#M171920 Gysbert_Wassenaar 2012-12-21T12:37:47Z Re: How do i calculate Closing rate? https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460492#M171921 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; it's showing total and when i put in stright table item wise showing zero's.</P><P>i used like this =FirstSortedValue(sld_rate,sld_ord_no)</P></BODY></HTML> Sat, 22 Dec 2012 07:03:49 GMT https://community.qlik.com/t5/QlikView/How-do-i-calculate-Closing-rate/m-p/460492#M171921 2012-12-22T07:03:49Z