topic Table correlation in App Development

Table correlation

diwaskarki — Sat, 16 Nov 2024 06:58:41 GMT

If I am creating two tables in qlikview by loading fields from the same qvd table. Those two tables seem to be correlated but I have no idea why. They dont have a common field name. Is it because they are subset of the same qvd table?

Re: Table correlation

achettipalli — Wed, 26 Dec 2018 20:18:50 GMT

Yes, Provided with same names and datatypes.

Re: Table correlation

uacg0009 — Thu, 27 Dec 2018 07:01:16 GMT

Hi Diwaskarki,
I think if the columns of these 2 tables are totally different, these 2 tables won't be correlated.
For example, if you won't set any table name in script, and there is a qvd called Country.
there are some columns in it, like A,B,C,D,E.
And in script:

Load A,B from Country.qvd(qvd);
Load C,D from Country.qvd(qvd);

Then Reload, I think you will get 2 tables(Country, Country-1) and no correlation.
Aiolos Zhao