About loosen

[#1]

Hi all,

I found an issue about loosen,

Now there are 3 tables:

Home:
load * Inline
[Name,Country
Borg,Sweden
George Bush, USA

];

Car:
load * Inline
[Name,Brand
Borg,Cadillac
George Bush, Volvo
];

Carmaker:
load * Inline
[Brand,Country
Cadillac, USA
Volvo, Sweden
];

LOOSEN table Carmaker;

Obviously, there is a circular references, if I use loosen table on Carmaker, then it will break Brand and Country.

But if I use a table object to show Carmaker, and select Country as Sweden, then the table results are:

Brand Country

Cadillac, Sweden

Volvo, Sweden

You could see that in orginal data, there is no relationship between Cadillac, Sweden.

Although loosen breaks the circular references, it shows the wrong data. I was wondering why shall we use loosen script?

Thanks.

Isaac .

[#2]

Instead of using loosen why don't you use an alias let say

for Home you can use Country and for Carmaker you can use Carmaker_Loc.

i think its more efficient that way.

[#3]

Hi,

Thanks for your reply, but it will load country dimension twice?

[#4 · Accepted solution]

that's why you will use an alias so that qlikview will not load country twice.

Carmaker:

Load Country as Carmaker_Loc

if your using an inline load you cannot use th "as" function but if your retrieving your data from a database or excel file you can use that.

[#5]

Thanks,

But I store the country code into the Carmaker and Home, and there is another table named DimCountry that store the real country name. If I rename the country name, the Carmaker will not connect to DimCountry table.

[#6]

you should've use an ID to be the reference to the real country name.