Urgent reply please

[#1]

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.

[Anonymous]

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

[Sokkorn]

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