Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FACT table

Hi Community

Quick question about FACT tables.  If I have a data model with tables that consist of different levels of granularity, can these tables all be combined into 1 fact table?

For example:-

  • Table 1 - Main table1
  •   Table A - Main order detail (multiple lines of the table 1)
  • Table B - Details of the Main order details  (multiple lines of table A)

Is it OK to combine table A and B into 1 fact table?

Thanks Community

Let me know if you need any more detail

1 Reply
Champion III
Champion III

Depends on how many rows of data are you expecting the FACT table to contain, are you going to do any count(Distinct ) calculations

Join your fact table one by one to see operational efficiency ...as long as you don't see any lag in your dashboard you should be fine...if you do then split your table again.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.