Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted

What is Circular reference? How to avoid them?

Hi All,

What are circular references and how to avoid them

Anand

17 Replies
Highlighted
Not applicable

What is Circular reference? How to avoid them?

Refer to qlik View reference manual..Pg No. 145.

Highlighted

What is Circular reference? How to avoid them?

Thanks of you. Its nice and helpful.

Anand

Regards

Highlighted
Not applicable

What is Circular reference? How to avoid them?

yes OK - but what if the home country and the car manufacturing

country are both important - i want to load the country table once and then join it to whereever i like/

Highlighted
Not applicable

What is Circular reference? How to avoid them?

Load the Country Table Twice but in second one call it country2:

Highlighted
Not applicable

What is Circular reference? How to avoid them?

you don't need a weather man to know to where the wind blows - it is not elegant - ther must be a way to load the data once.

Highlighted
Not applicable

What is Circular reference? How to avoid them?

I would suggest generating several key fields in the country table to tie to your various other tables.

i.e.

country:

load 'car_mfg'&country as car_mfg_country,

     country

from country_table;

car_mfg:

load 'car_mfg_&country as car_mfg_county,

     state,

     city,

     etc..

from car_mfg_table;

notice you aren't trying to tie the country field from the car_mfg_table to the country field from the country_table.

Highlighted
Not applicable

What is Circular reference? How to avoid them?

U missd the point - Country is a key in both the tables - Home & Carmaker (see p.146 in the manual).

In adition - lets take the situation one step forward - now lets consider that i have a big table of countries, with many columns, such as flag image, and population, area in square meters, UN symbol, continent, and many more.

the Q is - how to load the table once but use its data twice, without affecting eac other.

I believe it has to do with some design pattern such as using QVD or whatever.

Does QlickTech members are monitoring this forum?

Anybody?

Highlighted
jsn
Honored Contributor

What is Circular reference? How to avoid them?

What does your data model look like at the moment?

Highlighted
Not applicable

What is Circular reference? How to avoid them?

Thanks for responsing'

For the data model:

See page 146 in the manual and add one more table of countries.

For my Q:

I used to work few yesrs with microsoft SSAS and it was posible to load the countries table once and use its data as many times as you like, with the option to select CANDA as the Carmaker country and USA as the BuyerHome country.