Thanks for your time! This is probably an easy fix for you but I'm stuck finding a solution.
In my current data model, Reports are related to Questions which are related to Answers (see the attached Qlik app for details). The Location is set in the answer to the first question ("Where did the problem occur?") via the locationId and a hierarchy table called Locations.
![2020-04-29 15_26_58-Test Mapping App - Relationship Test Sheet _ Sheets - Qlik Sense.png 2020-04-29 15_26_58-Test Mapping App - Relationship Test Sheet _ Sheets - Qlik Sense.png](https://community.qlik.com/t5/image/serverpage/image-id/32657i7FC920A9C9C99A90/image-size/large?v=v2&px=999)
Relationships: Reports -> 1...* -> Questions -> 1...1 -> Answers -> 0...1 -> Locations
Problem
After importing the data, the location is only mapped to the answer where the locationId is set. This leads to side effects when I try to filter the data by location, as the question/answer without the location selection won't be displayed.
Question
How can I accomplish that the "selected" location is mapped to all available questions/answer for the given report?
![2020-04-29 15_53_45-Test Mapping App - Relationship Test Sheet _ Sheets - Qlik Sense.png 2020-04-29 15_53_45-Test Mapping App - Relationship Test Sheet _ Sheets - Qlik Sense.png](https://community.qlik.com/t5/image/serverpage/image-id/32659i677E52C01E0730C0/image-size/large?v=v2&px=999)
See the attached demo app for the structure and test data.