"One or more loops have been detected in your database structure."

[#1]

Hi all,

I'm new to qlikview and have a question connecting tables. I have three tables.

Table 1 has Name, WBS, Date, and Actual Spending

Table 2 has WBS, Group, and Organization

Table 3 has Name, Date and Budget

I want to create a bar chart to show actual spending and budget by Date. A list box should be available to select individual Name. Table 2 specifies which WBS's are included in which Group, and which Groups are included in which Organization. When I load the data, an error message shows up. Please help!

Thanks,

Samuel

[swuehl · Accepted solution]

Could you post a screenshot of your table view (open using CTRL-T)?

I think there should be more tables / fields involved to create the loop.

In general, have a look at:

Circular References

[Anonymous]

hello i renamed those fields that i want and still there's a loop its CustomerKey but CCS_CustomerKey fr a group of tables and PrP_CustomerKey for another.