linked table(urgent)

[#1]

hi

is there any concept named linked table in qlikview?? i need keys from two fact tables and both are attached to same dimensions. one fact table to 6 dimensions and other to 10.

is there any way to create a linked table which will have all the keys of both fact tables...

plz explain in detial????

[gauravkhare]

Hi Buddy,

Linktable is made generally to be used as binary in QlikView final reports..

LinkTable is nothing but a collection all the tables/fields..into a single application with proper data modelling ofcourse...

And it's this LinkTable that we use As Binary File in our final Reports.. It is very useful and a nice thing to have but remember not to use in all your qvw's because it tends to make your final application quite heavy

[gauravkhare]

Hi Buddy,

Linktable is made generally to be used as binary in QlikView final reports..

LinkTable is nothing but a collection all the tables/fields..into a single application with proper data modelling ofcourse...

And it's this LinkTable that we use As Binary File in our final Reports.. It is very useful and a nice thing to have but remember not to use in all your qvw's because it tends to make your final application quite heavy

[#4]

tell me how to make it??

syntax for it???

[SunilChauhan]

I think fact table itself is link table

if you have two different table then you can create a table using below

Tab1:

Load

Keyfield&'-'&(year*1000+Month*100+day) as a key

from table1;

Join(Tab1)

Load

Keyfield&'-'&(year*1000+Month*100+day) as a key     

from table2

from path

hope this helps