Can any one please help me to apply the below oracle rank() in Qlik backend script;
In Qlik we are working with QVD it contains the same fields mentioned in the below query.
partition by nvl(hm.datasecurityid, ds.datasecurityid), nvl(hm.riskfactorid, rf.riskfactorid)
order by hm.validfrom desc, hm.reportsource desc
) as rankfiled
Here hm.datasecurityid, ds.datasecurityid,hm.riskfactorid, rf.riskfactorid,hm.validfrom,hm.reportsource are the fields.
Thanks in advance.