topic only count the newest in QlikView https://community.qlik.com/t5/QlikView/only-count-the-newest/m-p/169284#M40132 <HTML><HEAD></HEAD><BODY><P>Hello Andreas,</P><P>You can use below script:</P><P></P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Tablename:<BR />Load<BR />ID<BR />Resident Tablename<BR />Where ID &lt;&gt; Previous(ID)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 05 Mar 2010 09:12:14 GMT 2010-03-05T09:12:14Z only count the newest https://community.qlik.com/t5/QlikView/only-count-the-newest/m-p/169283#M40131 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a table that contains n rows for one ID, now I would like to count only the newest row for the ID.</P><P>Propably my english is not so well, i will tell it also in german.</P><P></P><P>Ich hab eeine Tabelle mit Belegzeilen, es gibt dort mehrere Belege für eine eindeutige ID, zusätzlich gibt es ein Datumsfeld das, das Anlagedatum beschreibt. Ich möchte nun nur die Belege zählen pro ID die das aktuellste Datum haben.</P><P>Wie kann ich das realisieren?</P><P></P><P>Danke/Thanks</P><P>Gruß</P><P>Andreas</P><P></P></BODY></HTML> Fri, 05 Mar 2010 09:01:17 GMT https://community.qlik.com/t5/QlikView/only-count-the-newest/m-p/169283#M40131 2010-03-05T09:01:17Z only count the newest https://community.qlik.com/t5/QlikView/only-count-the-newest/m-p/169284#M40132 <HTML><HEAD></HEAD><BODY><P>Hello Andreas,</P><P>You can use below script:</P><P></P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Tablename:<BR />Load<BR />ID<BR />Resident Tablename<BR />Where ID &lt;&gt; Previous(ID)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 05 Mar 2010 09:12:14 GMT https://community.qlik.com/t5/QlikView/only-count-the-newest/m-p/169284#M40132 2010-03-05T09:12:14Z