topic Displaying rows with null date values in QlikView

Displaying rows with null date values

Wed, 06 Jan 2010 19:14:17 GMT

Hi,

I'm trying to make a bookmark using advanced search in order to display rows in a table with null date values.

When I set this :

= [date_test] <> ''

(the same with null()) or

=IsNull([date_test]) = 0

it works (displaying only rows without null values in this field, but when I try the opposite :

=[date_test] = ''

(the same with null())or

=IsNull([date_test]) = 1

it doesn't work. The filter doesn't give me good results. It should display rows with null values in this table.

Why ?

amien — Wed, 06 Jan 2010 22:58:04 GMT

Manual:

IsNull( expr )
Returns -1 (true) if expr returns NULL, otherwise 0 (false).

Tue, 26 Jul 2011 15:40:26 GMT

I am trying to create a bookmark to pull only those records where the data is in one table but no match in the other table.

Example:

Product ID is in Sales table but the Product ID is not yet added to the Product table.

THus the Product Name is Null in the query

I tried the below and no luck

=IsNull([Product Name]) = 1