topic Last Value Monthwise in QlikView https://community.qlik.com/t5/QlikView/Last-Value-Monthwise/m-p/569875#M682279 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need last rate of items from its rate field monthly and yearly itemwise.</P><P>I have year , Month, Items, Rate,Date fields. So , How can i get itemwise value monthly and yearly.</P><P>i tried</P><P>firstsortedvalue(Rate,-Date)</P><P>But it gave me some worng picture.</P><P>Similarly , I tried</P><P>Lastvalue(Rate). This also gave me Worng Picture. Anybody Please help. </P></BODY></HTML> Thu, 27 Mar 2014 12:32:04 GMT 2014-03-27T12:32:04Z Last Value Monthwise https://community.qlik.com/t5/QlikView/Last-Value-Monthwise/m-p/569875#M682279 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need last rate of items from its rate field monthly and yearly itemwise.</P><P>I have year , Month, Items, Rate,Date fields. So , How can i get itemwise value monthly and yearly.</P><P>i tried</P><P>firstsortedvalue(Rate,-Date)</P><P>But it gave me some worng picture.</P><P>Similarly , I tried</P><P>Lastvalue(Rate). This also gave me Worng Picture. Anybody Please help. </P></BODY></HTML> Thu, 27 Mar 2014 12:32:04 GMT https://community.qlik.com/t5/QlikView/Last-Value-Monthwise/m-p/569875#M682279 2014-03-27T12:32:04Z Re: Last Value Monthwise https://community.qlik.com/t5/QlikView/Last-Value-Monthwise/m-p/569876#M682281 <HTML><HEAD></HEAD><BODY><P>You can use</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">firstsortedvalue(DISTINCT Rate,-Date)</SPAN></P></BODY></HTML> Thu, 27 Mar 2014 12:59:08 GMT https://community.qlik.com/t5/QlikView/Last-Value-Monthwise/m-p/569876#M682281 MK_QSL 2014-03-27T12:59:08Z