Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The expressions are equal.
Any non-zero number in qlikview is evaluated as "True".
The isnull() function returns -1 (True) or 0 (false).
The expressions are equal.
Any non-zero number in qlikview is evaluated as "True".
The isnull() function returns -1 (True) or 0 (false).
Thank you so much for such a quick reply..
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)
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