I have an existing database I need to pull into Qlikview. I have the following structure (simplified - detailed table viewer export attached):
This structure creates a loop that Qlikview doesn't like - Claims are linked to Consumers both directly and via Policies. I need to be able to report on counts of claim actions for policy and non-policy claims together, so I can't just create completely separarate Policyclaimnumber and Nonpolicyclaimnumber structures. How can I get around this problem? Thanks for any help you can give.