topic How to filter the latest value of one data entry in App Development https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734431#M56102 <P>Hey,</P><P>I already searched for my problem, but I couldn't make it work.</P><P>I have this table what you see on the bottom. I have to build the sum of amount but just the latest value.&nbsp;</P><P>E.G. : Material-No 26 had in 2011 an amount of 0 and Mat-No 384 in May 2005 an amount of 3 so the sum is 3. every other amount for the same materialnumber that is earlier is no longer&nbsp;relevant. My problem is that I just can take the newest value of every material-no and need to build a sum.&nbsp;</P><TABLE width="465"><TBODY><TR><TD width="73">Material-No</TD><TD width="126">Year</TD><TD width="77">Month</TD><TD width="105">Amount</TD><TD width="84">Value</TD></TR><TR><TD>26</TD><TD>2009</TD><TD>12</TD><TD>10,000</TD><TD>80,00</TD></TR><TR><TD>26</TD><TD>2010</TD><TD>12</TD><TD>5,000</TD><TD>20,00</TD></TR><TR><TD>26</TD><TD>2011</TD><TD>2</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2005</TD><TD>5</TD><TD>3,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2005</TD><TD>8</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2009</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2010</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2011</TD><TD>4</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9541</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9541</TD><TD>2009</TD><TD>8</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9621</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9621</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2009</TD><TD>8</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9631</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9631</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9631</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9631</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR></TBODY></TABLE> Mon, 20 Dec 2021 21:08:46 GMT nici_prm 2021-12-20T21:08:46Z How to filter the latest value of one data entry https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734431#M56102 <P>Hey,</P><P>I already searched for my problem, but I couldn't make it work.</P><P>I have this table what you see on the bottom. I have to build the sum of amount but just the latest value.&nbsp;</P><P>E.G. : Material-No 26 had in 2011 an amount of 0 and Mat-No 384 in May 2005 an amount of 3 so the sum is 3. every other amount for the same materialnumber that is earlier is no longer&nbsp;relevant. My problem is that I just can take the newest value of every material-no and need to build a sum.&nbsp;</P><TABLE width="465"><TBODY><TR><TD width="73">Material-No</TD><TD width="126">Year</TD><TD width="77">Month</TD><TD width="105">Amount</TD><TD width="84">Value</TD></TR><TR><TD>26</TD><TD>2009</TD><TD>12</TD><TD>10,000</TD><TD>80,00</TD></TR><TR><TD>26</TD><TD>2010</TD><TD>12</TD><TD>5,000</TD><TD>20,00</TD></TR><TR><TD>26</TD><TD>2011</TD><TD>2</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>384</TD><TD>2005</TD><TD>5</TD><TD>3,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>886</TD><TD>2005</TD><TD>8</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2009</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2010</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>3703</TD><TD>2011</TD><TD>4</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9541</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9541</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9541</TD><TD>2009</TD><TD>8</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9621</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9621</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9621</TD><TD>2009</TD><TD>8</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9631</TD><TD>2003</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9631</TD><TD>2004</TD><TD>12</TD><TD>0,000</TD><TD>0,00</TD></TR><TR><TD>9631</TD><TD>2007</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR><TR><TD>9631</TD><TD>2008</TD><TD>12</TD><TD>1,000</TD><TD>15,00</TD></TR></TBODY></TABLE> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734431#M56102 nici_prm 2021-12-20T21:08:46Z Re: How to filter the latest value of one data entry https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734784#M56133 <P>Hi,</P><P>I think you need to use FirstSortedValue, so something like the attached (you may need to do something about year/month &amp; aggregation, depends on your underlying data).</P><P>Cheers,</P><P>Chris.</P> Tue, 11 Aug 2020 11:42:08 GMT https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734784#M56133 chrismarlow 2020-08-11T11:42:08Z Re: How to filter the latest value of one data entry https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734789#M56134 <P>I already tried this, but I couldn't make it work, this is why i am asking.</P> Tue, 11 Aug 2020 12:02:13 GMT https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734789#M56134 nici_prm 2020-08-11T12:02:13Z Re: How to filter the latest value of one data entry https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734797#M56137 <P>Hi,</P><P>Maybe if you share some screenshots of what is not working that would help.</P><P>Cheers,</P><P>Chris.</P> Tue, 11 Aug 2020 12:22:07 GMT https://community.qlik.com/t5/App-Development/How-to-filter-the-latest-value-of-one-data-entry/m-p/1734797#M56137 chrismarlow 2020-08-11T12:22:07Z