Skip to main content

Solving circular references

When circular references occur, you need to edit the load script by assigning a unique name to one of the fields with identical names.

Do the following:

  1. Open the script editor.
  2. Edit the LOAD statement for one of the duplicate field names.

    In this example, the LOAD statement of the table that holds the local teams and their cities would include with a new name for Team, for example LocalClub. The updated LOAD statement reads:

    LOAD City, Team as LocalClub

  1. Reload the script.

You now have logic that works throughout all the tables. In this example, when Italy is selected, the national team, the German cities and the local clubs of each city are associated:

Four fields: Country, Team, City, and LocalClub.

When you open the table viewer, you see that the loosely coupled connections are replaced with regular connections:

The Country fields and the City fields are strongly associated. The Team and LocalClub fields are not associated.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com