topic Re: Sum only latest value in QlikView https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481525#M555488 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="45282" class="jive-image-thumbnail jive-image" onclick="" alt="firstsortervalue.PNG" src="https://community.qlik.com/legacyfs/online/45282_firstsortervalue.PNG" width="450" /></P><P>I could only attach this and all I wanted is to sum only the most recent value in the m_Sum Assured.</P><P></P><P>Kwame</P></BODY></HTML> Sun, 11 Aug 2013 07:10:23 GMT Anonymous 2013-08-11T07:10:23Z Sum only latest value https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481523#M555486 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Polices may have multiple transactions, I would want to sum amounts for only the latest transactions assuming the date keeps updating each time but the amount field keeps several layers. So for instance when i click on a policy it displays only the latest date but several occurences of the amount which when summed gives undesirable result.</P><P></P><P>Kwame</P><P></P><P>Thanks</P></BODY></HTML> Fri, 09 Aug 2013 18:33:02 GMT https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481523#M555486 Anonymous 2013-08-09T18:33:02Z Re: Sum only latest value https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481524#M555487 <HTML><HEAD></HEAD><BODY><P>could you have any sample application or data..</P><P></P><P>or else try to use the firstsortedvalue function.</P><P></P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Fri, 09 Aug 2013 19:06:55 GMT https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481524#M555487 sushil353 2013-08-09T19:06:55Z Re: Sum only latest value https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481525#M555488 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="45282" class="jive-image-thumbnail jive-image" onclick="" alt="firstsortervalue.PNG" src="https://community.qlik.com/legacyfs/online/45282_firstsortervalue.PNG" width="450" /></P><P>I could only attach this and all I wanted is to sum only the most recent value in the m_Sum Assured.</P><P></P><P>Kwame</P></BODY></HTML> Sun, 11 Aug 2013 07:10:23 GMT https://community.qlik.com/t5/QlikView/Sum-only-latest-value/m-p/481525#M555488 Anonymous 2013-08-11T07:10:23Z