Replacing IsNull
IsNull is a function that has similarities in many programming languages. It is not always the same though. In QlikView, this function returns a Boolean value of true or false; if the passed value is null.
There is a big "however" here though. Depending upon the version of QlikView that you have, IsNull does not always return what you expect. There are differences between 32-bit and 64-bit versions on how the values are handled. It should also be noted that blank values in text files or inline data will be treated as empty strings rather than null.
SQL Server developers will be familiar with the SQL function of ISNULL (or COALESCE) that, instead of just returning a Boolean value, will return a default value if the passed value ...
Get QlikView for Developers Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
