topic Urgent reply please in QlikView

Urgent reply please

Thu, 06 Jun 2013 09:47:28 GMT

Hi......can any one help me to get this issue .......i have like this script in orcle "NVL2(MPS_ID, 'MPS', 'NON MPS') AS MPS_FLAG" , how can we use in qlikview mainly that NVL2 function...

Thanks $ Regards,

sh.

Re: Urgent reply please

Anonymous — Thu, 06 Jun 2013 09:59:20 GMT

Taken from Oracle help documentation:

"NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered."

I would used an if statements testing for a null (or I actually prefer to test for a length of 0).

if(Len(MPS_ID)>0, 'MPS', 'NON MPS') AS MPS_FLAG

Jonathan

Re: Urgent reply please

Sokkorn — Thu, 06 Jun 2013 10:04:07 GMT

Hi,

Try this

If(IsNull(MPS_ID),'NON MPS','MPS') AS MPS_FLAG

Or If(Not IsNull(MPS_ID),'MPS','NON MPS') AS MPS_FLAG

And do not "Assumed Answered" when your issue is not resolve.

Regards,

Sokkorn