SQL over clause to Qlik

[jeckstein]

I have the following line of code use in a SQL statement:

row_number() over (partition by EmpiEID order by EmpiEID, Claims DESC ,MaxServiceDate )  as ord

I need to do this same function but in Qlik.

Any thoughts?

[sunny_talwar]

Would you be able to share a small dataset and how the output looks like after running this statement in SQL?

[maxgro]

try the attachment