topic linked table(urgent) in QlikView

linked table(urgent)

Tue, 10 Apr 2012 10:31:58 GMT

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????

linked table(urgent)

gauravkhare — Tue, 10 Apr 2012 11:12:43 GMT

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

Re: linked table(urgent)

gauravkhare — Tue, 10 Apr 2012 11:14:42 GMT

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...

linked table(urgent)

Tue, 10 Apr 2012 11:36:45 GMT

tell me how to make it??

syntax for it???

linked table(urgent)

SunilChauhan — Tue, 10 Apr 2012 11:43:56 GMT

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