Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How do I remove synthetic keys?

Hi all,

I'm having trouble building my table relationship in Qlikview.  I have four tables: CSA, Template, Orders, and Customers.  A customer can have a CSA or a Template (not both).  I sense that this may be causing some redundancy but I'm not sure how to remove it.  Any advice?  I've attached an image of my relationships to make it easier to see.

Cheers

image.png

1 Solution

Accepted Solutions
3 Replies
Highlighted
Partner
Partner

Re: How do I remove synthetic keys?

Not only synthetic keys, but circular references too!

Highlighted
Creator
Creator

Re: How do I remove synthetic keys?

Cheers, had a read through, just need to change my data model.