topic How to compare data in a table? in QlikView

How to compare data in a table?

Tue, 07 Feb 2012 09:40:23 GMT

Hi,

I have one table that holds data of invoices. I want to test if I have duplicate invoices. A duplicate invoice is an invoice with the same invoice number, customer name, invoice date and invoice amount.

Do you have any idea how I could build up this test an generate a table with these duplicate invoices?

Thanks in advance!

Kind regards,

Jens

How to compare data in a table?

swuehl — Tue, 07 Feb 2012 09:53:20 GMT

Maybe just create a straight table with dimensions invoice number, customer name, invoice date and invoice amount and one expression:

= if(count([invoice date]) >1,1,0)

This should flag and filter (if supress zero values is enabled in presentation tab) your duplicates.

Hope this helps,

Stefan

Re: How to compare data in a table?

Wed, 08 Feb 2012 09:30:34 GMT

Thanks a lot this indeed solved my problem!

Kind regards,

Jens