topic Re: Composite Keys in QlikView https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005462#M968679 <HTML><HEAD></HEAD><BODY><P>Maybe a key compound of various fields, for instance, if you have a Sales Order + Position.</P><P></P><P>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.&nbsp; If you do not do this, QV make a synthetic key, referring the two fields.&nbsp; In this case see the online manual.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99874_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 23 Sep 2015 20:10:02 GMT jolivares 2015-09-23T20:10:02Z Composite Keys https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005461#M968678 <HTML><HEAD></HEAD><BODY><P>What is&nbsp; Composite Key And uasge scenario</P></BODY></HTML> Wed, 23 Sep 2015 06:56:57 GMT https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005461#M968678 2015-09-23T06:56:57Z Re: Composite Keys https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005462#M968679 <HTML><HEAD></HEAD><BODY><P>Maybe a key compound of various fields, for instance, if you have a Sales Order + Position.</P><P></P><P>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.&nbsp; If you do not do this, QV make a synthetic key, referring the two fields.&nbsp; In this case see the online manual.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99874_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 23 Sep 2015 20:10:02 GMT https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005462#M968679 jolivares 2015-09-23T20:10:02Z Re: Composite Keys https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005463#M968680 <HTML><HEAD></HEAD><BODY><P>See this</P><P></P><P>hope help</P><P><A href="https://community.qlik.com/thread/55976">Synthetic table, Composite Key &amp;amp; Model issue</A></P><P></P><P><A href="https://community.qlik.com/thread/112891">how to create composite key</A></P></BODY></HTML> Wed, 23 Sep 2015 23:10:14 GMT https://community.qlik.com/t5/QlikView/Composite-Keys/m-p/1005463#M968680 fkeuroglian 2015-09-23T23:10:14Z