This might be a confusing one to explain but I'll try my best.
I have three different data sources that I need to link together to report on. They are coming from different databases in a hospital and all have the unique patient identifier (MRN) so this is the only way that I know I can link the tables together. Each of the databases contains different information on an event that could happen to a patient (e.g. cardiac arrest, patient alarms etc).
I also want to be able to filter by date and show what has happened on certain dates to give me totals of how many of these events occurred on a certain day. This is where things get difficult. I have created a 'DateLink' table using the date/time stamp for each table and then linked the DateKey to a master calendar.
Now, when I filter using this DateKey field, I get way more than just the date that I am filtering on (even when I use the DateType field as a filter that I have created in the DateLink table). I believe this has something to do with the MRN being a common field. Qlik is seeing that there are more 'things' happening with that MRN in other tables then, coming back and grabbing those 'dates' from the initial table.
This is hard to explain. I have provided screenshots of the Table Viewer and a testing page I have created with the dates from each table along with the DateKey and DateType (with a single DateKey and DateType filter highlighted). Unfortunately, can't share the whole Qlikview file due to the nature of the information. Any information or help on how to accurately filter the dates would be great.