topic FirstSortedValue or Similar? in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409665#M152342 <HTML><HEAD></HEAD><BODY><P>Morning everyone, </P><P></P><P>Can someone please help me regrading FirstsortedValue or something similar. </P><P></P><P>I'm currently trying to get the latest meter readings using FirstSortedValue as follows, based on a key i've created which is made up of&nbsp; Date&amp;''&amp;Time</P><P></P><P>FirstSortedValue(Meter_Read, -Key, 1)</P><P>FirstSortedValue(Meter_Read, -Key, 2)</P><P>FirstSortedValue(Meter_Read, -Key, 3)</P><P></P><P>to get the subsequent read. </P><P></P><P>My problem is when the two keys are the same, qlikview does not bring any data. </P><P></P><P>Any way to solve this issue please?</P><P></P><P>Best Regards. </P></BODY></HTML> Wed, 07 Nov 2012 09:01:09 GMT buddhabang 2012-11-07T09:01:09Z FirstSortedValue or Similar? https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409665#M152342 <HTML><HEAD></HEAD><BODY><P>Morning everyone, </P><P></P><P>Can someone please help me regrading FirstsortedValue or something similar. </P><P></P><P>I'm currently trying to get the latest meter readings using FirstSortedValue as follows, based on a key i've created which is made up of&nbsp; Date&amp;''&amp;Time</P><P></P><P>FirstSortedValue(Meter_Read, -Key, 1)</P><P>FirstSortedValue(Meter_Read, -Key, 2)</P><P>FirstSortedValue(Meter_Read, -Key, 3)</P><P></P><P>to get the subsequent read. </P><P></P><P>My problem is when the two keys are the same, qlikview does not bring any data. </P><P></P><P>Any way to solve this issue please?</P><P></P><P>Best Regards. </P></BODY></HTML> Wed, 07 Nov 2012 09:01:09 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409665#M152342 buddhabang 2012-11-07T09:01:09Z Re: FirstSortedValue or Similar? https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409666#M152343 <HTML><HEAD></HEAD><BODY><P>You can use DISTINCT qualifier to get a result, the first in load order AFAIR.</P><P></P><P>FirstSortedValue(DISTINCT Meter_Read, -Key, 1)</P><P></P><P>Or try creating your own sort order for equal keys by adding some small values depending in other fields.</P></BODY></HTML> Wed, 07 Nov 2012 09:36:25 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409666#M152343 swuehl 2012-11-07T09:36:25Z Re: FirstSortedValue or Similar? https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409667#M152344 <HTML><HEAD></HEAD><BODY><P>Thanks Swuehl, i used distinct and it worked like a peach. Thanks a lot</P></BODY></HTML> Wed, 07 Nov 2012 10:16:52 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-or-Similar/m-p/409667#M152344 buddhabang 2012-11-07T10:16:52Z