Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
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.
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