topic Re: Loosely Coupled Table in QlikView

Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 05:47:19 GMT

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

Re: Loosely Coupled Table

tyagishaila — Wed, 02 Sep 2015 07:19:26 GMT

rename key field in one table.

Re: Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 08:17:14 GMT

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

Re: Loosely Coupled Table

qlikviewwizard — Wed, 02 Sep 2015 08:24:37 GMT

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.

Re: Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 08:28:25 GMT

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

Re: Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 08:28:54 GMT

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?

Re: Loosely Coupled Table

qlikviewwizard — Wed, 02 Sep 2015 08:30:11 GMT

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.

Re: Loosely Coupled Table

qlikviewwizard — Wed, 02 Sep 2015 08:30:45 GMT

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

Re: Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 08:40:00 GMT

Hey,

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

Re: Loosely Coupled Table

qlikviewwizard — Wed, 02 Sep 2015 08:41:46 GMT

Hi,

I did not understand

Re: Loosely Coupled Table

hic — Wed, 02 Sep 2015 08:43:38 GMT

It is more or less random which table QlikView chooses to decouple.

In my opinion, the "loosely coupled" is an emergency action so QlikView can show anything at all. Without it, a selection wouldn't be well defined so it would not be possible to show anything.

HIC

Re: Loosely Coupled Table

nikhilgarg — Wed, 02 Sep 2015 08:48:49 GMT

Thank HIC,

So, i should assume it is a random selection of loosely coupled table, ryt ?

Re: Loosely Coupled Table

hic — Wed, 02 Sep 2015 09:23:45 GMT

It loosens the table that happens to be loaded first, of the tables that participate in the loop.

HIC