Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Synthetic Keys required?

Hi All,

I still consider myself new to Qlikview.  I'm the only one at the company who is designing, developing, and administering anything.  I also have an accounting background, so some of this stuff is still lost on me, but I'm learning and having a blast.

We're working with Dynamics GP2013.  I've noticed that sometimes my data seems to break when I DON'T have a synthetic key.  It seems that the data that makes the most sense to join on is only partial in one table.  In an Accounts Receivable app I'm building, the data doesn't seem to work if I don't join on both Customer Number AND Document Number.

Is this normal, or is there something that I am missing? 

Also - if anyone knows of any Qlikview Dynamics GP groups, please point them out to me. 

Thanks!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Synthetic Keys required?

In that case create a composite key

[Customer Number] & '|' & [Document Number] as JoinKey

to join your respective tables..

So you both tables looks like below

Table1:

[Customer Number] & '|' & [Document Number] as JoinKey,

[Customer Number],

[Document Number]

From .....



Table2:

[Customer Number] & '|' & [Document Number] as JoinKey,

//[Customer Number],

//[Document Number]

From .....

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: Synthetic Keys required?

In that case create a composite key

[Customer Number] & '|' & [Document Number] as JoinKey

to join your respective tables..

So you both tables looks like below

Table1:

[Customer Number] & '|' & [Document Number] as JoinKey,

[Customer Number],

[Document Number]

From .....



Table2:

[Customer Number] & '|' & [Document Number] as JoinKey,

//[Customer Number],

//[Document Number]

From .....

View solution in original post

Highlighted
Creator
Creator

Re: Synthetic Keys required?

Manish,

Thanks for the help and the detailed answer. 

Does this have any effect on anything other than eliminating the Synthetic Key?

Wouldn't you comment out the Customer Number and the Document Number from one of each table?  Won't that continue to create a synthetic key?

Highlighted
MVP
MVP

Re: Synthetic Keys required?

If you remove Customer Number and Document Number from one of the table, this will not create a Synthetic Key and the tables would be joined by JoinKey.... Also, both the removed fields are available to both table through the JoinKey

Highlighted
Creator
Creator

Re: Synthetic Keys required?

Ah - I didn't see that you commented out the field. 

Thanks!

Highlighted
MVP
MVP

Re: Synthetic Keys required?

If you get your reply, please close the thread...