oracle nvl() in qlik

[mahitham]

Hi Experts,

I am trying to replicate the Oracle Query logic  in Qlik. We cant directly run the query.

We are extracting each table from data base, doing joins as per query and performing the logics in Qlik.

Can any one please help me to replicate the  below highlighted  red color nvl() logic in Qlik.

Table:

Select

productname,

paidamount,

productno

from Product p

inner join sales  s on p.id = s.id

where p.date = s.date

and (

    nvl(p.productname, 0)  != 0

or nvl(p.paidamount, 0)    !=0

or nvl(p.productno, 0)       !=0

)

Thanks in advance.

[jonathandienst · Accepted solution]

ORACLE

and (

     nvl(p.productname, 0)   != 0

     or nvl(p.paidamount, 0) !=0

     or nvl(p.productno, 0)  !=0

)

QLIKVIEW

and(

     IsNull(productname) = 0

     or IsNull(paidamount) = 0

     or IsNull(productno) = 0

)

[sasiparupudi1]

and (

    Len(Trim(p.productname))>0

or Alt(p.paidamount, 0) <>0

or Len(Trim(p.productno))>0

)

[mahitham]

Hi Sasidhar,

Thanks for your reply.

I didn't understand why Alt taken for p.paidamount . could you please explain once.

[sasiparupudi1]

No Particular reason..you can use len(trim()) for that also.. Alt generally works with numeric values..seeing that asa n amount field, I thought of using alt.