Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nikhilgarg
Valued Contributor

Loosely Coupled Table

Hey,

If i have a circular reference then on what basis does qlikview  make a table loosely coupled by itself?

Can anyone help em in this?

Thanks

12 Replies
tyagishaila
Valued Contributor

Re: Loosely Coupled Table

rename key field in one table.

nikhilgarg
Valued Contributor

Re: Loosely Coupled Table

Hey,

Thanks but i want to know that what is the difference if we create qvd's from STORE and BUFFER command except for following differences:

1: Buffer will create qvd automatically .

2: Location is different for STORE and BUFFER created qvd's.

3: Name is different for qvd's created by both ways.

Any other difference?

Thanks

qlikviewwizard
Honored Contributor II

Re: Loosely Coupled Table

You can eliminate circular reference by the following methods.

-rename the fields,

- Create composite key,

-remove unnecessary fields

-create link table

-join the tables

-concatenate the tables

If you are not able to do, please attach the sample file with the data.

Thank you.

nikhilgarg
Valued Contributor

Re: Loosely Coupled Table

Hey Thanks,

But what i want to know is if there is a circular reference made after loading data then we see that under document settings , under tables tab, qlikview already made a table loosely coupled. So is it a random selection of table or is there any criteria for selecting table as loosely coupled?

Thanks

nikhilgarg
Valued Contributor

Re: Loosely Coupled Table

Hey,

Thanks but i want to know that what is the difference if we create qvd's from STORE and BUFFER command except for following differences:

1: Buffer will create qvd automatically .

2: Location is different for STORE and BUFFER created qvd's.

3: Name is different for qvd's created by both ways.

Any other difference?

qlikviewwizard
Honored Contributor II

Re: Loosely Coupled Table

Hi Nikhil,

This different from the question you asked in the post.

Please close the thread by selecting Correct Answer and Helpful answers and start the new thread.

Thank you.

qlikviewwizard
Honored Contributor II

Re: Loosely Coupled Table

Please close the thread and start the new thread. Thank you.

nikhilgarg
Valued Contributor

Re: Loosely Coupled Table

Hey,

Ya i know, i pasted it in other thread but don't know what's going wrong...

qlikviewwizard
Honored Contributor II

Re: Loosely Coupled Table

Hi,

I did not understand