topic Re: Any functions? in QlikView

Any functions?

keerthika — Thu, 12 Apr 2018 10:16:37 GMT

Hi,

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

Regards,

keerthika

keerthika — Fri, 13 Apr 2018 06:45:07 GMT

can someone help me?

baarathi — Fri, 13 Apr 2018 07:06:18 GMT

Hi Keerthika, keerthika

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

keerthika — Fri, 13 Apr 2018 07:10:43 GMT

Hi,

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

jonathandienst — Fri, 13 Apr 2018 07:12:21 GMT

If they are numeric, then:

Alt(Col1, Col2)

If they are any value:

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

baarathi — Fri, 13 Apr 2018 07:21:37 GMT

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 — Fri, 13 Apr 2018 08:36:01 GMT

Thanks for your reply. I got it.