topic Object to identify Missing/Unmatched in QlikView

Object to identify Missing/Unmatched

robinsond31 — Wed, 27 Jun 2012 20:29:32 GMT

Is there a simple way to set up and object to identify records in one table that have missing or unmatched fields in another table? I tried setting up a table box, a pivot table chart, and a straight table chart, and I was not able to get what I wanted.

I have two tables. One loads shipment information. The other is a manually updated excel table that has conversion factors for units of measures. If a shipment is made with a new or previously unused product, I have to add a record with unit of measure conversion factors in the excel table. I would like an object to show me immediately after data refresh if I need to add a new record.

Re: Object to identify Missing/Unmatched

robinsond31 — Tue, 30 Apr 2013 14:36:41 GMT

Is there anyone out there who can help with this?

Re: Object to identify Missing/Unmatched

kaushiknsolanki — Tue, 30 Apr 2013 16:17:19 GMT

Hi,

You can do this in script. Something like shown below.

Sales:

Load Product_Code, Date,Sales From Sales;

Left join

Load Product_Code, Product_Information from Product.xls;

Sales_Final:

Load *,if(isnull(Product_Information),'No Info Available','Info Available') as Product_Info_Identifier

Resident Sales;

Drop table Sales;

Regards,

Kaushik Solanki

Re: Object to identify Missing/Unmatched

robinsond31 — Tue, 30 Apr 2013 18:31:03 GMT

Kaushik,

I was looking for something more like a text box or pivot table. I did find a solution. A pivot table with a NullCount aggregate function on a field in the table that would have missing data.

Thanks for your help.

David