- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is Circular reference? How to avoid them?
Hi All,
What are circular references and how to avoid them
Anand
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Refer to qlik View reference manual..Pg No. 145.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks of you. Its nice and helpful.
Anand
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load the Country Table Twice but in second one call it country2:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What does your data model look like at the moment?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »