Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
markp201
Contributor III

Same grain with some common dimensions

See below.

We concatenated two facts because they have a common primary key (%FactKey)

In order to concatenate do all the dimensions have to be common?

Do all measures have to be common between the fact tables?

We're only get rows for dimension2 but is there a way to dimension1 rows?

1 Solution

Accepted Solutions
effinty2112
Honored Contributor

Re: Same grain with some common dimensions

Hi Mark,

I know nothing about your data so take this with some healthy skepticism. Did your original fact tables share common values of %FactKey? Were the fact fields in one table different from the fact fields in the other? If the answer to both of these answers is yes then that would suggest the your new fact table should be created from a join of the original tables rather than concatenation.

Good luck

Andrew

2 Replies
effinty2112
Honored Contributor

Re: Same grain with some common dimensions

Hi Mark,

I know nothing about your data so take this with some healthy skepticism. Did your original fact tables share common values of %FactKey? Were the fact fields in one table different from the fact fields in the other? If the answer to both of these answers is yes then that would suggest the your new fact table should be created from a join of the original tables rather than concatenation.

Good luck

Andrew

markp201
Contributor III

Re: Same grain with some common dimensions

Thanks for the reply but now the ba is asking for the other side of the coin.  They're asking for measures from fact table 1 be appended to fact table 2 where the conforming dimension key matches.  it doesn't seem like this is wise because any aggregation will be skewed.  I'll try to add a visual later.