Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Would you be able to share a small dataset and how the output looks like after running this statement in SQL?
try the attachment