Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

2 Replies
Anonymous
Not applicable

Hi,

The aim in data modelling within QlikView is a star model, not a single table.  A star model gives better performance than a single table.  So, it would be a good idea to use a link table.

marcus_sommer

For me it didn't sound that your mentioned three tables are fact-tables by which it would be an option to concatenate them and which then led to your adding example of the records.

If you have really a few records you shouldn't change nothing on this datamodel - the association between the tables will be work very well. Are there a lot more data and/or further tables then it could be useful to merge some of the tables per joining or often easier and more performant per mapping.

I suggest to start from here: Get started with developing qlik datamodels

- Marcus