topic Re: oracle nvl() in qlik in QlikView

oracle nvl() in qlik

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: oracle nvl() in qlik

jonathandienst — Wed, 11 Apr 2018 09:42:51 GMT

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

)

Re: oracle nvl() in qlik

sasiparupudi1 — Wed, 11 Apr 2018 09:44:40 GMT

and (

Len(Trim(p.productname))>0

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

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

)

Re: oracle nvl() in qlik

mahitham — Wed, 11 Apr 2018 09:52:49 GMT

Hi Sasidhar,

Thanks for your reply.

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

Re: oracle nvl() in qlik

sasiparupudi1 — Wed, 11 Apr 2018 10:01:06 GMT

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.