Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.