Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Facts tables

Whats the best way to add lots of facts tables, like sales, activity, history. I have been adding them by concatenate to one table with "Sale" as Entity, "activity"  as Entity. But wondered if there was a better way.

2 Replies
Honored Contributor II

Re: Facts tables

That's how I've been doing it to.

The star or snowflake schema is the way Qlik works with the data best.

Contributor II

Re: Facts tables

Concatenate is used when the granuality of your fact table is mostly same i.e. 7 out of 10 fields are same.

If only 2-3 fields are same then use a link table.