Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to handle multiple fact tables

Hi All,

I am bit weak in handling multiple fact tables with different levels of granularity .Please share some examples how to deal.

Thanks,

R.Rand

5 Replies
Gysbert_Wassenaar

See this blog post: Fact Table with Mixed Granularity


talk is cheap, supply exceeds demand
Kushal_Chawda

You can either concatenate fact tables or you can create Link table based on the scenarios.

Please find the below link for better understanding of both approach

http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

manojkulkarni
Partner - Specialist II
Partner - Specialist II

You can concatenate both the tables into a single fact table. If you provide some sample data then it will be easy to suggest the better approach.

Anonymous
Not applicable
Author

I have 8 fact tables .Is it advisable to concatenate even at  different levels of granularity.

sgrice
Partner - Creator II
Partner - Creator II

If they Share Dimensions but are at different levels of summary then Concatenate them together;

Load

'Detail' as Level,

*

from myDetailTable;

Concatenate

Load

'Summary' as Level,

*

from mySummaryTable;

Note that if you have a field that you sum and do not want to effect existing charts then load summary fields into different fields

I.e. SALES field is in both Detail and Summary. Then Rename the Summary on SUMofSALES. This way you can use either SUM(SALES) or SUM(SUMofSALES) and they will give you same answer.

You can also do nice things like  SUM(SALES)/SUM(SUMofSALES) would give the % of the Sales by Summary Level.