topic About loosen in QlikView

About loosen

Tue, 04 Jan 2011 03:34:56 GMT

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 .

About loosen

Tue, 04 Jan 2011 04:04:05 GMT

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.

About loosen

Tue, 04 Jan 2011 04:10:08 GMT

Hi,

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

About loosen

Tue, 04 Jan 2011 04:15:52 GMT

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.

About loosen

Tue, 04 Jan 2011 04:21:31 GMT

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.

About loosen

Tue, 04 Jan 2011 04:25:37 GMT

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