topic linked table(urgent) in QlikView

linked table(urgent)

Tue, 10 Apr 2012 10:33:11 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????

Re: linked table(urgent)

Tue, 10 Apr 2012 14:42:58 GMT

Hi,

Could you add exmples of the information you need linked and what you are trying to do with them? You can link tables in QlikView by having a common-named field but depending on what you are trying to do that may or may not be what you are after.

If we have some sample data to look at I'm sure the requirement would be a bit more clear.

Thanks,

Emma

Re: linked table(urgent)

goldnejea8 — Tue, 10 Apr 2012 17:27:04 GMT

You can create a link table between the fact tables using concatenated keys if no common keys exist. It can get pretty resource intensive however if you have a huge amount of data.

Re: linked table(urgent)

Tue, 05 Jun 2012 07:05:33 GMT

Hi,

You can see the link below which explains your scenario with link table in detail.

http://www.quickqlearqool.nl/?p=910

Hope this help,

Anosh