topic Re: SQL over clause to Qlik in QlikView https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221005#M390389 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a small dataset and how the output looks like after running this statement in SQL?</P></BODY></HTML> Mon, 06 Feb 2017 19:26:18 GMT sunny_talwar 2017-02-06T19:26:18Z SQL over clause to Qlik https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221004#M390388 <HTML><HEAD></HEAD><BODY><P>I have the following line of code use in a SQL statement:</P><P></P><P class="p1"><SPAN class="s1">row_number</SPAN>() over (partition by EmpiEID order by EmpiEID, Claims DESC ,MaxServiceDate )&nbsp; as ord </P><P class="p1"></P><P class="p1"></P><P class="p1">I need to do this same function but in Qlik.</P><P class="p1"></P><P class="p1">Any thoughts?</P></BODY></HTML> Mon, 06 Feb 2017 19:09:09 GMT https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221004#M390388 jeckstein 2017-02-06T19:09:09Z Re: SQL over clause to Qlik https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221005#M390389 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a small dataset and how the output looks like after running this statement in SQL?</P></BODY></HTML> Mon, 06 Feb 2017 19:26:18 GMT https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221005#M390389 sunny_talwar 2017-02-06T19:26:18Z Re: SQL over clause to Qlik https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221006#M390390 <HTML><HEAD></HEAD><BODY><P>try the attachment</P></BODY></HTML> Mon, 06 Feb 2017 19:27:22 GMT https://community.qlik.com/t5/QlikView/SQL-over-clause-to-Qlik/m-p/1221006#M390390 maxgro 2017-02-06T19:27:22Z