Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

SHow Rows with Missing Data in reference table only

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

Tags (1)
5 Replies
deepakk
Valued Contributor III

SHow Rows with Missing Data in reference table only

hi,

I think it should be

IsNull([Product Name]) = -1 .

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

Deepak

Not applicable

SHow Rows with Missing Data in reference table only

I think I found it

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

Not applicable

Re: SHow Rows with Missing Data in reference table only

I think I found it

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

Not applicable

Re: SHow Rows with Missing Data in reference table only

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

Not applicable

Re: SHow Rows with Missing Data in reference table only

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

Community Browser