1 Reply Latest reply: Apr 17, 2018 4:32 AM by youssef belloum RSS

    Rank() Help

    P Kumar

      Hi Experts


      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.


         rank() over(

                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.