- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Loop in database structure
Hi All
I have three tables like this:
When I reload the scripts, this message appears:
One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.
So my question is, how can I avoid getting this error.
Thanks in advance.
Regards,
Ashkan
- Tags:
- loop
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would put Sales Data and Target in the same table: Concatenate the target data with the actual data.
Then I would use a generic key for the calendar, i.e. a key that can mean both a month and a date. See more on Fact Table with Mixed Granularity
HIC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would put Sales Data and Target in the same table: Concatenate the target data with the actual data.
Then I would use a generic key for the calendar, i.e. a key that can mean both a month and a date. See more on Fact Table with Mixed Granularity
HIC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Henric
Thank you very much.