topic Re: Issue with expression in QlikView https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923135#M980363 <HTML><HEAD></HEAD><BODY><P>Thanks Neetha. It worked. Thanks for all the help.</P></BODY></HTML> Thu, 13 Aug 2015 18:54:43 GMT 2015-08-13T18:54:43Z Issue with expression https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923131#M980359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone please help me with this requirement.</P><P>I have multiple records of "Paynet Construction Score" for each "Transaction ID". But I want to show only the latest Paynet Construction Score record for each Transaction ID.</P><P></P><P>Thank you in advance.</P><P>Regards,<BR />Sachin</P></BODY></HTML> Thu, 13 Aug 2015 15:37:46 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923131#M980359 2015-08-13T15:37:46Z Re: Issue with expression https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923132#M980360 <HTML><HEAD></HEAD><BODY><P>Hi Aditya,</P><P></P><P>check out the Qlikview Help for FirstSortedValue()</P><P></P><P>Andy</P></BODY></HTML> Thu, 13 Aug 2015 15:52:02 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923132#M980360 awhitfield 2015-08-13T15:52:02Z Re: Issue with expression https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923133#M980361 <HTML><HEAD></HEAD><BODY><P>What do you mean by latest score?</P><P>If you have date or timestamp against each score, you can use as below</P><P></P><P>Straight Table</P><P></P><P>Dimension</P><P>[Transaction ID]</P><P></P><P>Expression</P><P>FirstSortedValue(Score,-Date)</P><P>or</P><P><SPAN style="font-size: 13.3333330154419px;">FirstSortedValue(Aggr(SUM(Score),Date,[Transaction ID]),-Date)</SPAN></P></BODY></HTML> Thu, 13 Aug 2015 15:55:40 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923133#M980361 MK_QSL 2015-08-13T15:55:40Z Re: Issue with expression https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923134#M980362 <HTML><HEAD></HEAD><BODY><P>Hi Aditya,</P><P></P><P>Use&nbsp; aggr functions to grouping data based on dimension <SPAN style="font-size: 13.3333330154419px;">[Transaction ID] and Date.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"> and</SPAN> <SPAN style="font-size: 13.3333330154419px;">firstsortedvalue function for getting higest or lowest value for <SPAN style="font-size: 13.3333330154419px;">[Paynet Construction Score]</SPAN></SPAN> .</P><P></P><P>=FirstSortedValue(Aggr(SUM([Paynet Construction Score]),Date,[Transaction ID]),-Date)</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Thu, 13 Aug 2015 16:14:25 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923134#M980362 Anonymous 2015-08-13T16:14:25Z Re: Issue with expression https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923135#M980363 <HTML><HEAD></HEAD><BODY><P>Thanks Neetha. It worked. Thanks for all the help.</P></BODY></HTML> Thu, 13 Aug 2015 18:54:43 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/923135#M980363 2015-08-13T18:54:43Z