rank() in qlik

[mahitham]

Hi Experts,

jontydkpi

Can any one please help me to create the below 3  oracle fields from query into Qlik.

Select

nvl(h.id, d.id)  as id,                                                                   //   ...................... 1

nvl(h.productid, r.productid) as productid,                                //   ................2

rank() over(

partition by nvl(h.id, d.id) , nvl(h.productid, r.productid)

order by h.validfrom desc, h.reportource desc

)      as varrank                                                                         //  ......................... 3

from hours h

Thanks in advance

[vishsaggi]

What happens when you do this?

LOAD *;

SQL

Select

nvl(h.id, d.id)  as id,                                                                 

nvl(h.productid, r.productid) as productid,                               

rank() over(

partition by nvl(h.id, d.id) , nvl(h.productid, r.productid)

order by h.validfrom desc, h.reportource desc

)      as varrank                                                                        

from hours h;

[mahitham]

hi nagaraju,

I cant run the query its a big oracle query.

I have to extract each table from database and need to replicate the oracle logics into qlik.