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.

      petter-s