Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Composite Keys

What is  Composite Key And uasge scenario

2 Replies
jolivares
Specialist
Specialist

Maybe a key compound of various fields, for instance, if you have a Sales Order + Position.

In Table T2 you have SalesOrd and PosNr, but they are in two separate fields, likewise in table T3, so you have group into one field.  If you do not do this, QV make a synthetic key, referring the two fields.  In this case see the online manual.

Capture.PNG

fkeuroglian
Partner - Master
Partner - Master