Any functions?

[keerthika]

Hi,

     Is there is a function in qlik like NVL2 in oracle?

Regards,

keerthika

[keerthika]

can someone help me?

[baarathi · Accepted solution]

Hi Keerthika, keerthika

There is function called ISNULL. If you got the answer please mark correct and close the thread,

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/NULLFunctions/null-...

[keerthika]

Hi,

Thank you , i din't know ISNULL has NVL2 functionality.

[jonathandienst]

If they are numeric, then:

    Alt(Col1, Col2)

If they are any value:

    If(IsNull(Col1), expression-if-null, expression-if-not-null)

[baarathi]

Hi, keerthika‌

NVL2 ( expr1 , expr2 , expr3 😞 If expr1 is null, then NVL2 returns expr3. If expr1 is not null, then NVL2 returns expr2

This is function of NVL2

We can use ISNULL in similar way in Qlik, Use the below expression

If(ISNULL(Expr1) = -1 , Expr3,Expr2)

[keerthika]

Thanks for your reply. I got it.