topic Re: display rows only when fields from two tables are equal in QlikView

display rows only when fields from two tables are equal

Margaret — Wed, 19 Oct 2016 17:04:04 GMT

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.

Re: display rows only when fields from two tables are equal

Gysbert_Wassenaar — Wed, 19 Oct 2016 17:31:48 GMT

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.