display rows only when fields from two tables are equal

[Margaret]

I have a field in one table called DocDate and a field in another table called AuditDate. Can I create a Listbox with 'Y' & 'N' (or other object) so that my chart (which contains data from both tables) displays only rows where DocDate = AuditDate?

I tried this as an Expression in a ListBox:

     =if(DocumentDate = AuditDate, 'Y', 'N')

But it doesn't work.

[Gysbert_Wassenaar]

Probably because a single DocumentDate is associated to multiple AuditDates. You will probably have to create a new field for this in the script. Possibly you'll have to join tables too so there's a table that contains both fields so that the values of the two dates can be compared on a record by record basis. Perhaps you can post a small Qlikview document that illustrates the problem.