What is Circular reference? How to avoid them?

[its_anandrjs]

Hi All,

What are circular references and how to avoid them

Anand

[#2]

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

[its_anandrjs]

Thanks of you. Its nice and helpful.

Anand

Regards

[#4]

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/

[#5]

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

[#6]

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.

[#7]

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.

[#8]

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?

[Anonymous]

What does your data model look like at the moment?

[#10]

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.