Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Multiple fact tables

Hi all,

I have multiple fact tables that can share many dimensions.

I have fact tables such as Student_Modules, Student_Courses, Student_Years and dimensions such as Modules, Courses, Students etc.

I have started to build a link table, although not sure if concatenating of these fact tables would not be more useful.

Any suggestions?

T.

P.S. I have read already about it here: Generic keys and here: Concatenate vs Link Table

Tags (3)
5 Replies
MVP
MVP

Re: Multiple fact tables

Kindly provide your data model or list of fields from multiple fact tables.

Partner
Partner

Re: Multiple fact tables

Sorry Manish. I cannot provide you this.

Partner
Partner

Re: Multiple fact tables

any takers?

Not applicable

Re: Multiple fact tables

Hi,

I think there is hard to help without some more facts.  But I would guess that LinkTable is a good choice. 

I can recommend the book by Barry Harmsen - QlikView 11 for Developers, chapter 8

// Fjalar

Not applicable

Re: Multiple fact tables

Hi Tereza,

It's hard to help out on this without fact tables details.

Okay try to concatenate or create a link table to avoid synthetic keys.