Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

What is Circular reference? How to avoid them?

Hi All,

What are circular references and how to avoid them

Anand

17 Replies
Not applicable

What is Circular reference? How to avoid them?

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

What is Circular reference? How to avoid them?

Thanks of you. Its nice and helpful.

Anand

Regards

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/

Not applicable

What is Circular reference? How to avoid them?

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

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.

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.

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?

jsn
Honored Contributor

What is Circular reference? How to avoid them?

What does your data model look like at the moment?

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.

Community Browser