Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Please help with removal of syn key

1 Solution

Accepted Solutions
MVP
MVP

Re: Please help with removal of syn key

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

Synthetic Keys

8 Replies
gautik92
Valued Contributor III

Re: Please help with removal of syn key

Have a look at this pdf

MVP
MVP

Re: Please help with removal of syn key

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

Synthetic Keys

Re: Please help with removal of syn key

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.
Not applicable

Re: Please help with removal of syn key

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

Re: Please help with removal of syn key

Hi,

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

MVP
MVP

Re: Please help with removal of syn key

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

Re: Please help with removal of syn key

Thanks Guys

Not applicable

Re: Please help with removal of syn key

Hi,

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

Community Browser