topic Re: Expression help in QlikView

Expression help

Mon, 10 Nov 2014 13:35:19 GMT

Hi,

What is the difference between the two expressions mentioned below:

1. if(isnull(ID),'N/A',ID)

2. if(isnull(ID)=-1,'N/A',ID)

Does the isnull function return some value?

Re: Expression help

simenkg — Mon, 10 Nov 2014 13:37:35 GMT

The expressions are equal.

Any non-zero number in qlikview is evaluated as "True".

The isnull() function returns -1 (True) or 0 (false).

Re: Expression help

Mon, 10 Nov 2014 13:44:09 GMT

Thank you so much for such a quick reply..

Re: Expression help

Mon, 10 Nov 2014 13:44:13 GMT

1. if(isnull(ID),'N/A',ID) - if id filed is having null values then returns N/A other wise it returns id

2. if(isnull(ID)=-1,'N/A',ID -- here when isnull(id)=-1 when id field is having null values then only expression true , if it is true returns N/A otherwise id

isnull function:

isnull(expr) - returns -1(true) otherwise 0(false)

Re: Expression help

MK_QSL — Mon, 10 Nov 2014 13:44:46 GMT

Both are same...

If(IsNull(ID), FORTRUE, FORFALSE)

IsNull(ID) means any ID having NULL() values.... This will return some values....
as Simen replied, all Non_Zero numbers are true in qlikview