topic SHow Rows with Missing Data in reference table only in QlikView

SHow Rows with Missing Data in reference table only

Tue, 26 Jul 2011 15:41:50 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

deepakk — Tue, 26 Jul 2011 15:48:19 GMT

hi,

I think it should be

IsNull([Product Name]) = -1 .

If you can attach a sample application then it would be more clear.

Deepak

Tue, 26 Jul 2011 15:55:48 GMT

I think I found it

=if(IsNull(ProductField),1,0)

Tue, 26 Jul 2011 15:56:01 GMT

I think I found it

=if(IsNull(ProductField),1,0)

Tue, 26 Jul 2011 15:57:56 GMT

But it doesn't work with all my validation tables oddly enough. Works with Product reference table but not with Partner reference table

Tue, 26 Jul 2011 15:58:02 GMT

But it doesn't work with all my validation tables oddly enough. Works with Product reference table but not with Partner reference table