3 Replies Latest reply: Mar 28, 2013 5:10 AM by Gysbert Wassenaar RSS

    Loop in database and switching dataset for presentation

      I am trying to get two similar (big) Expense datasets to load into Qlikview. Most columns are the same except the expense values, which vary as they have been drawn from two different systems, say A and B. However, even as data from A links okay, the data from B is giving me a loop error (probably because it's similar to the data from A and connects to all the other tables in the EXACT same way as A) 

       

      I get this error: "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."

       

      I need the loop to go but do not want to concatenate the two tables.

       

      As a next step, I also want the functionality of being able to select data from systems A and B using radio buttons, except i don't know how to make the data switch. For instance,  in a bar chart, i want it to show Expense_A when i select A and Expense_B when system B is selected. The issue is that i have to choose Expression as Expense_A (or B) so it doesn't change to Expense_B (or A) if you change the selection.

       

      Sorry if it's confusing and utterly incoherent! Please try and help?