Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help with removal of syn key

1 Solution

Accepted Solutions
maxgro
MVP
MVP

why? your model works and you only have 1 syn key

Synthetic Keys

View solution in original post

8 Replies
gautik92
Specialist III
Specialist III

Have a look at this pdf

maxgro
MVP
MVP

why? your model works and you only have 1 syn key

Synthetic Keys

PrashantSangle

Hi,

You can remove syn Key by using concept of Composite Key

or Rename field which is causing for Synthetic Key.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi,

Either change the name of the field Date in calendar.

Also check our primary key, which one you need as a primary key and which tables you need to associate.

Thanks and regards

Khushboo

Not applicable
Author

Hi,

Better create a link table with all the common fields in all the table.

jonathandienst
Partner - Champion III
Partner - Champion III

Before asking this question it is important to understand the meanings of the fields in the key and how they are likely to be used. Here the date field reflects 2 distinct dates - a sales date and a purchase date, and the sales and purchases are linked via the product key.

Have a look at this article on multiple date fields - you may land up with a more useful final model.

Canonical Date

Apart from that, I agree with Massimo - there is no real need to remove this key.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Guys

Not applicable
Author

Hi,

if u have got help from any of the answers u mark it as helpful or correct