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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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