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.
That's how I've been doing it to.
The star or snowflake schema is the way Qlik works with the data best.
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.
Retrieving data ...