Common challenges of Data modeling

When you start data model for your Qlik Sense application which involves linking tables together, you may come across common challenges which may make your data model behave unexpectedly.

Let us have a look at some of the challenges which you may come across.

Synthetic Keys

Qlik Sense developers are aware that whenever you have common field names in two or more tables, Qlik Sense links them together automatically. When you have one field which is common, then you don't have a problem; it is a clean linking between them. However, when you have two or more fields that are common, Qlik automatically generates the synthetic keys and synthetic table.

Every time you reload the script, and...