Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Synthetic Key Issue

I'm trying to figure out a way to connect 2 groups of 4 tables with two different fields names without getting a synthetic key.  1 group of 4 is connected by the group name Operating Period.  The other is connected by the field name Unit Number.  One table links the two groups right now by having both fields names in it.  This all works fine.

The issue I am running into is that a couple of tables on both groups that have a field called year in them as well.  I need to link them by Year as well as, but not have a synthetic key.  Is that something obtainable?

2 Replies
Valued Contributor

Re: Synthetic Key Issue

It depends on what do you need from the data model, but you can create link table with year, or concatenate the tables into one.


New Contributor III

Re: Synthetic Key Issue


The end result is that the majority, if not all, of my charts/graphs need to have either a dimension of (Unit Number) or (Year), but not all tables have Year in the information.

I did make a link table for (Operating Period) and (Unit Number), but have no idea how to make another one without setting up a synthetic key.

Community Browser