Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

Synthetic keys importance

Can someone please explain about the concept of synthetic keys and their usage if any. Want to know how a synthetic table is formed when two tables are joined and two tables are concatenated.
2 Replies
Honored Contributor

Re: Synthetic keys importance

I think the Qlik Sense Help are defining and explaining the synthetic keys in a good way. The concept of composite keys are handled the same in both QlikView and Qlik Sense.

I quote:
When two or more data tables have two or more fields in common, this suggests a composite key relationship. Qlik Sense handles this by creating synthetic keys automatically. These keys are anonymous fields that represent all occurring combinations of the composite key.

Read more at https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/synthetic-...
Please ekskuse my Norglish and Swenglish typos.

Re: Synthetic keys importance

Here is a Design Blog post as well that may be of some use in explaining things too:



To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.