topic Data from the last Timeline for every Year in App Development https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936736#M13069 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I have a list of hundreds of projects . Each project has many timelines . I need the latest timeline annually.</SPAN></P></BODY></HTML> Wed, 02 Dec 2015 11:43:46 GMT marcoebner 2015-12-02T11:43:46Z Data from the last Timeline for every Year https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936736#M13069 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I have a list of hundreds of projects . Each project has many timelines . I need the latest timeline annually.</SPAN></P></BODY></HTML> Wed, 02 Dec 2015 11:43:46 GMT https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936736#M13069 marcoebner 2015-12-02T11:43:46Z Re: Data from the last Timeline for every Year https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936737#M13070 <HTML><HEAD></HEAD><BODY><P>Perhaps change the dimension </P><P></P><P>from:&nbsp;&nbsp; &lt;Date&gt;</P><P></P><P>To:&nbsp;&nbsp;&nbsp; Aggr( Max( &lt;Date&gt;) , &lt;Project&gt;, &lt;Year&gt; ) </P><P></P><P>You may need to change your load editor to include a Year field</P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;Date&gt;</P><P>from &lt;&gt;</P><P></P><P>-&gt;</P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;Date&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Year(&lt;Date&gt;) as Year</P><P>from &lt;&gt;</P></BODY></HTML> Wed, 02 Dec 2015 17:21:36 GMT https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936737#M13070 JonnyPoole 2015-12-02T17:21:36Z Re: Data from the last Timeline for every Year https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936738#M13071 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Good solution , thanks for the support</SPAN></P></BODY></HTML> Thu, 03 Dec 2015 08:48:59 GMT https://community.qlik.com/t5/App-Development/Data-from-the-last-Timeline-for-every-Year/m-p/936738#M13071 marcoebner 2015-12-03T08:48:59Z