Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Response Urgently required -Is it ok to have natural joins in data model

I have multiple tables loaded in the data model. Is it ok to use natural joins - associations to link multiple tables in the qlikview data model. These tables are maintained as it is and not grouped as facts and dimensions. Is it ok to  use the tables as it is using these natural joins in the data model for publishing it to a live dashboard in production. (They are not grouped as facts and dimensions- is this ok)

2 Replies
Clever_Anjos
Employee
Employee

Qlikview is very permissive about your data model.

It does not enforces using a dimensional model (however, it´s better to use it for clarity, performance and so on)

As long you don´t have inconsistencies and performance issues you can live with your model

maxgro
MVP
MVP

you can read

To Join or not to Join