Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

linked table(urgent)

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

3 Replies
Not applicable

Re: linked table(urgent)

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

goldnejea8
Not applicable

Re: linked table(urgent)

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.

Link Table.png

Not applicable

Re: linked table(urgent)

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