topic Re: Linking Fact tables in QlikView

Linking Fact tables

NavinReddy — Wed, 29 May 2013 11:01:57 GMT

Hi All,

I have a problem could some help me

im getting three Fact Tables How can i linking those Three Fact Table

any body help me

Thanks & Regards

Niranjan

Re: Linking Fact tables

sushil353 — Wed, 29 May 2013 11:04:25 GMT

If they have similar fields then use concatenate statement..

also you can link them using composite key if they have multiple common fields.

HTh

Sushil

Re: Linking Fact tables

Wed, 29 May 2013 11:04:59 GMT

for linking all three table , one field must be unique . if no any field are unique in all,then write

Rowno() as key in all three

Re: Linking Fact tables

Wed, 29 May 2013 11:08:29 GMT

sample1:

fact1:

load

C , rowno() as key

FROM FACT1;

fact2:

load

E,
rowno() as key

FROM fact2;

fact3:

load

G, rowno() as key

FROM fact3;

****************************************

Re: Linking Fact tables

Wed, 29 May 2013 11:27:16 GMT

Hi,

If you three fact tables then you can form a single Link Table composing of these 3 Fact Tables .

Because there will be possibility that these fact tables might be sharing more than 1 dimension table in common .

So you can try to have a single Link table.

Regards

Yusuf

Re: Linking Fact tables

NavinReddy — Wed, 29 May 2013 11:43:07 GMT

Hi All,

Thank you guys for Quick repose

really its help full to me

Thanks & Regards

Niranjan

Re: Linking Fact tables

Wed, 29 May 2013 11:47:44 GMT

if your problem resolved then marked it as either correct or helpful according to your question so that it might be helpful for other developer

Regards

vishwaranjan