https://community.qlik.com/t5/QlikView/Linking-fields/m-p/1817000#M1213089 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132984">@AmCh</a>&nbsp;</P><P>&nbsp;</P><P>Please refer to below article:</P><P><A href="https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/#:~:text=The%20link%20table%20must%20have%20distinct%20records.%20Step,the%20fact%20tables%20Step-3%20Load%20other%20dimension%20tables." target="_blank">How To Remove Synthetic Keys in Qlikview (analyticsvidhya.com)</A></P><P>&nbsp;</P><P>Thanks,</P><P>Padma Priya</P><P>Qlik Support</P> Tue, 22 Jun 2021 14:20:01 GMT PadmaPriya 2021-06-22T14:20:01Z https://community.qlik.com/t5/QlikView/Linking-fields/m-p/1816518#M1213056 <P>Hi all,</P><P>I have the following fields as an example:</P><TABLE border="1"><TBODY><TR><TD>System</TD></TR><TR><TD>A1</TD></TR><TR><TD>A2</TD></TR><TR><TD>A3</TD></TR><TR><TD>B1</TD></TR><TR><TD>B2</TD></TR><TR><TD>B3</TD></TR><TR><TD>C1</TD></TR><TR><TD>C2</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Subsystem A</TD></TR><TR><TD>A1</TD></TR><TR><TD>A2</TD></TR><TR><TD>A3</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Subsystem B</TD></TR><TR><TD>B1</TD></TR><TR><TD>B2</TD></TR><TR><TD>B3</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Subsystem C</TD></TR><TR><TD>C1</TD></TR><TR><TD>C2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>Desired output:</STRONG></P><P>Based on selections in Subsystems (A,B and C) I want to notify (with symbol, text e.g. 'selected',...) in field System, which values are selected in subfields.</P><P>Supposing: <STRONG>A1</STRONG>, <STRONG>B3</STRONG> and <STRONG>C2</STRONG> are selected in fields <STRONG><U>Subsystem A,B &amp; C</U></STRONG> respectively from the end user.</P><P>Results in field <STRONG><U>System</U></STRONG>:</P><TABLE border="1"><TBODY><TR><TD>System</TD></TR><TR><TD>A1&nbsp; &nbsp; <STRONG>selected</STRONG></TD></TR><TR><TD>A2</TD></TR><TR><TD>A3</TD></TR><TR><TD>B1</TD></TR><TR><TD>B2</TD></TR><TR><TD>B3&nbsp; &nbsp;<STRONG>selected</STRONG></TD></TR><TR><TD>C1</TD></TR><TR><TD>C2&nbsp; &nbsp;<STRONG>selected</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Any help please?</P><P>Thanks in advance</P> Mon, 21 Jun 2021 11:04:41 GMT https://community.qlik.com/t5/QlikView/Linking-fields/m-p/1816518#M1213056 AmCh 2021-06-21T11:04:41Z https://community.qlik.com/t5/QlikView/Linking-fields/m-p/1817000#M1213089 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132984">@AmCh</a>&nbsp;</P><P>&nbsp;</P><P>Please refer to below article:</P><P><A href="https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/#:~:text=The%20link%20table%20must%20have%20distinct%20records.%20Step,the%20fact%20tables%20Step-3%20Load%20other%20dimension%20tables." target="_blank">How To Remove Synthetic Keys in Qlikview (analyticsvidhya.com)</A></P><P>&nbsp;</P><P>Thanks,</P><P>Padma Priya</P><P>Qlik Support</P> Tue, 22 Jun 2021 14:20:01 GMT https://community.qlik.com/t5/QlikView/Linking-fields/m-p/1817000#M1213089 PadmaPriya 2021-06-22T14:20:01Z