I am still struggling in my first steps with Qlik, so please bear with me!
I have successfully loaded my tables and was able to set up some basic filters.
I have two tables which are linked by date through a Canonical Calendar (please see attached image).
Now I want to be able to filter these 2 tables not only based on the date, but also on city.
My first approach was to set a filter for the first table and have Qlik "copy" this filter to the second table, but that doesn't seem to work as Qlik "replaces" one filter for the other instead of keeping them both. I have tried to "toggle select", placed 2 list boxes, but in all cases, Qlik replaces one filter for the other. (please see attached images)
Between those fields are no respectively the right associations available - you could see it quite clearly within the listboxes - if you select one item you need to see items with white background-color into the other listbox and not only one one with a grey background-color.
I think you will need to rethink your whole datamodel. For this try to reduce the number of fact-tables (by concatenating/mapping/joining) and if possible avoid link-tables to go in direction of a star-scheme - this isn't mandatory necessary to create a working datamodel in qlik but it's often the easiest way to create a datamodel and avoids potentially problems with unsuccessful associations.