topic FUNCTION QVD? in QlikView https://community.qlik.com/t5/QlikView/FUNCTION-QVD/m-p/380715#M142007 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">USE</SPAN> <SPAN class="hps">THIS FUNCTION</SPAN> <SPAN class="hps">TO</SPAN> <SPAN class="hps">COUNT</SPAN> <SPAN class="hps">IN</SPAN> <SPAN class="hps">SQL</SPAN>, <SPAN class="hps">WANT</SPAN> <SPAN class="hps">TO USE</SPAN> <SPAN class="hps">ON A</SPAN> <SPAN class="hps">QVD</SPAN> <SPAN class="hps">HOWTO.</SPAN></P><P> <SPAN class="hps">ROW_NUMBER</SPAN> <SPAN class="hps">()</SPAN> <SPAN class="hps atn">OVER (</SPAN>PARTITION BY <SPAN class="hps">TerritoryName</SPAN> <SPAN class="hps">SalesYTD</SPAN> <SPAN class="hps">ORDER BY</SPAN> <SPAN class="hps">DESC</SPAN>)</P><P></P><P></P><P></P><P><SPAN class="hps">THANKS</SPAN>.</P></BODY></HTML> Fri, 24 Aug 2012 14:48:26 GMT rogeriobarbosa 2012-08-24T14:48:26Z FUNCTION QVD? https://community.qlik.com/t5/QlikView/FUNCTION-QVD/m-p/380715#M142007 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">USE</SPAN> <SPAN class="hps">THIS FUNCTION</SPAN> <SPAN class="hps">TO</SPAN> <SPAN class="hps">COUNT</SPAN> <SPAN class="hps">IN</SPAN> <SPAN class="hps">SQL</SPAN>, <SPAN class="hps">WANT</SPAN> <SPAN class="hps">TO USE</SPAN> <SPAN class="hps">ON A</SPAN> <SPAN class="hps">QVD</SPAN> <SPAN class="hps">HOWTO.</SPAN></P><P> <SPAN class="hps">ROW_NUMBER</SPAN> <SPAN class="hps">()</SPAN> <SPAN class="hps atn">OVER (</SPAN>PARTITION BY <SPAN class="hps">TerritoryName</SPAN> <SPAN class="hps">SalesYTD</SPAN> <SPAN class="hps">ORDER BY</SPAN> <SPAN class="hps">DESC</SPAN>)</P><P></P><P></P><P></P><P><SPAN class="hps">THANKS</SPAN>.</P></BODY></HTML> Fri, 24 Aug 2012 14:48:26 GMT https://community.qlik.com/t5/QlikView/FUNCTION-QVD/m-p/380715#M142007 rogeriobarbosa 2012-08-24T14:48:26Z