Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rgvavihs
Valued Contributor

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
MVP & Luminary
MVP & Luminary

Re: How to handle multiple fact tables

See this blog post: Fact Table with Mixed Granularity


talk is cheap, supply exceeds demand

Re: How to handle multiple fact tables

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/

Partner
Partner

Re: How to handle multiple fact tables

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.

rgvavihs
Valued Contributor

Re: How to handle multiple fact tables

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

Partner
Partner

Re: How to handle multiple fact tables

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.