topic Re: Creating Key that will be linked to 2 fields in the table in QlikView https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905177#M1217878 <P>Such problems are best solved by creating a data model that represents the logic you want; i.e. you need to change the script. In your example, the solution is probably to create a third field "Branch" that contains the values of both "Branch1" and "Branch2":</P><P>Load &lt;SomeAppropriateKey&gt;, Branch1 as Branch Resident ...<BR />Load &lt;SomeAppropriateKey&gt;, Branch2 as Branch Resident ...</P><P>See also <A href="https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578</A> where a similar problem for dates is solved this way.</P><P>HIC</P> Tue, 15 Mar 2022 08:55:44 GMT hic 2022-03-15T08:55:44Z Creating Key that will be linked to 2 fields in the table https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905103#M1217877 <P>Good day</P> <P>&nbsp;</P> <P>Please assist,I have two fields branch1 and Branch2 i would like to make a selection from another field that will produce the results of data associated with the selected branch on both branches.</P> <P>&nbsp;</P> <P>e.g see below example,if i select branch=1,i would like to see everything associated with Branch =1 on both Branch1 and Branch2 fields.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ditshele_0-1647327380484.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74455i707A442D2577453C/image-size/medium?v=v2&amp;px=400" role="button" title="Ditshele_0-1647327380484.png" alt="Ditshele_0-1647327380484.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Mar 2022 07:01:06 GMT https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905103#M1217877 Ditshele 2022-03-15T07:01:06Z Re: Creating Key that will be linked to 2 fields in the table https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905177#M1217878 <P>Such problems are best solved by creating a data model that represents the logic you want; i.e. you need to change the script. In your example, the solution is probably to create a third field "Branch" that contains the values of both "Branch1" and "Branch2":</P><P>Load &lt;SomeAppropriateKey&gt;, Branch1 as Branch Resident ...<BR />Load &lt;SomeAppropriateKey&gt;, Branch2 as Branch Resident ...</P><P>See also <A href="https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578</A> where a similar problem for dates is solved this way.</P><P>HIC</P> Tue, 15 Mar 2022 08:55:44 GMT https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905177#M1217878 hic 2022-03-15T08:55:44Z Re: Creating Key that will be linked to 2 fields in the table https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905805#M1217907 <P>It works perfectly.T hanks!</P> Wed, 16 Mar 2022 08:13:12 GMT https://community.qlik.com/t5/QlikView/Creating-Key-that-will-be-linked-to-2-fields-in-the-table/m-p/1905805#M1217907 Ditshele 2022-03-16T08:13:12Z