topic One field (tab1) in relation to several fields (tab2) in Francophones https://community.qlik.com/t5/Francophones/One-field-tab1-in-relation-to-several-fields-tab2/m-p/819315#M6144 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">HI</SPAN>,<BR /><BR /> <SPAN class="hps">I</SPAN> <SPAN class="alt-edited hps">have a slightly</SPAN> <SPAN class="alt-edited hps">complex question.</SPAN><BR /> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">in relation to two</SPAN> <SPAN class="hps">other</SPAN> <SPAN class="hps">fields in the same</SPAN> <SPAN class="hps">table.</SPAN><BR /> <SPAN class="hps">as in the following</SPAN> <SPAN class="hps">example:</SPAN><BR /><BR /> <SPAN class="hps">ISNULL</SPAN> <SPAN class="atn hps">(</SPAN>(SELECT <SPAN class="hps">FROM</SPAN> <SPAN class="hps">TA.TBL_LIB</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">WHERE</SPAN> <SPAN class="hps">YOUR</SPAN> <SPAN class="hps">TA.TBL_ID</SPAN> <SPAN class="atn hps">= '</SPAN>FC1' AND <SPAN class="hps">TA.TBL_CODE</SPAN> <SPAN class="hps">T.FC1_CODE</SPAN> <SPAN class="hps">=</SPAN>), '') <SPAN class="hps">AS</SPAN> <SPAN class="hps">C1</SPAN> <SPAN class="hps">Third</SPAN> <SPAN class="atn hps">'</SPAN><BR /> <SPAN class="hps">ISNULL</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>(SELECT</SPAN> <SPAN class="hps">FROM</SPAN> <SPAN class="hps">TA.TBL_LIB</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">WHERE</SPAN> <SPAN class="hps">YOUR</SPAN> <SPAN class="hps">TA.TBL_ID</SPAN> <SPAN class="atn hps">= '</SPAN>FC2' AND <SPAN class="hps">TA.TBL_CODE</SPAN> <SPAN class="hps">T.FC2_CODE</SPAN> <SPAN class="hps">=</SPAN>), '') <SPAN class="hps">AS</SPAN> <SPAN class="hps">C2</SPAN> <SPAN class="hps">Third</SPAN> <SPAN class="atn hps">'</SPAN><BR /><BR /> <SPAN class="hps">TBL_ID</SPAN> <SPAN class="alt-edited hps">is in relation with</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">FC1_CODE</SPAN> <SPAN class="hps">and is also</SPAN> <SPAN class="hps">related to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">FC2_CODE</SPAN>.<BR /><BR /> <SPAN class="hps">How to</SPAN> <SPAN class="hps">realize</SPAN> <SPAN class="hps">this relationship in</SPAN> <SPAN class="hps">Qlikview</SPAN>?<BR /><BR /> <SPAN class="hps">How to translate</SPAN> <SPAN class="hps">this</SPAN> <SPAN class="hps">SQL query</SPAN>?<BR /><BR /> <SPAN class="hps">T:</SPAN> <SPAN class="hps">THIRD</SPAN> <SPAN class="hps">TABLE</SPAN><BR /> <SPAN class="hps">TA:</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">TABLE</SPAN></SPAN></P></BODY></HTML> Wed, 12 Nov 2014 13:42:40 GMT 2014-11-12T13:42:40Z One field (tab1) in relation to several fields (tab2) https://community.qlik.com/t5/Francophones/One-field-tab1-in-relation-to-several-fields-tab2/m-p/819315#M6144 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">HI</SPAN>,<BR /><BR /> <SPAN class="hps">I</SPAN> <SPAN class="alt-edited hps">have a slightly</SPAN> <SPAN class="alt-edited hps">complex question.</SPAN><BR /> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">in relation to two</SPAN> <SPAN class="hps">other</SPAN> <SPAN class="hps">fields in the same</SPAN> <SPAN class="hps">table.</SPAN><BR /> <SPAN class="hps">as in the following</SPAN> <SPAN class="hps">example:</SPAN><BR /><BR /> <SPAN class="hps">ISNULL</SPAN> <SPAN class="atn hps">(</SPAN>(SELECT <SPAN class="hps">FROM</SPAN> <SPAN class="hps">TA.TBL_LIB</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">WHERE</SPAN> <SPAN class="hps">YOUR</SPAN> <SPAN class="hps">TA.TBL_ID</SPAN> <SPAN class="atn hps">= '</SPAN>FC1' AND <SPAN class="hps">TA.TBL_CODE</SPAN> <SPAN class="hps">T.FC1_CODE</SPAN> <SPAN class="hps">=</SPAN>), '') <SPAN class="hps">AS</SPAN> <SPAN class="hps">C1</SPAN> <SPAN class="hps">Third</SPAN> <SPAN class="atn hps">'</SPAN><BR /> <SPAN class="hps">ISNULL</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>(SELECT</SPAN> <SPAN class="hps">FROM</SPAN> <SPAN class="hps">TA.TBL_LIB</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">WHERE</SPAN> <SPAN class="hps">YOUR</SPAN> <SPAN class="hps">TA.TBL_ID</SPAN> <SPAN class="atn hps">= '</SPAN>FC2' AND <SPAN class="hps">TA.TBL_CODE</SPAN> <SPAN class="hps">T.FC2_CODE</SPAN> <SPAN class="hps">=</SPAN>), '') <SPAN class="hps">AS</SPAN> <SPAN class="hps">C2</SPAN> <SPAN class="hps">Third</SPAN> <SPAN class="atn hps">'</SPAN><BR /><BR /> <SPAN class="hps">TBL_ID</SPAN> <SPAN class="alt-edited hps">is in relation with</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">FC1_CODE</SPAN> <SPAN class="hps">and is also</SPAN> <SPAN class="hps">related to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">FC2_CODE</SPAN>.<BR /><BR /> <SPAN class="hps">How to</SPAN> <SPAN class="hps">realize</SPAN> <SPAN class="hps">this relationship in</SPAN> <SPAN class="hps">Qlikview</SPAN>?<BR /><BR /> <SPAN class="hps">How to translate</SPAN> <SPAN class="hps">this</SPAN> <SPAN class="hps">SQL query</SPAN>?<BR /><BR /> <SPAN class="hps">T:</SPAN> <SPAN class="hps">THIRD</SPAN> <SPAN class="hps">TABLE</SPAN><BR /> <SPAN class="hps">TA:</SPAN> <SPAN class="hps">TABLES</SPAN> <SPAN class="hps">TABLE</SPAN></SPAN></P></BODY></HTML> Wed, 12 Nov 2014 13:42:40 GMT https://community.qlik.com/t5/Francophones/One-field-tab1-in-relation-to-several-fields-tab2/m-p/819315#M6144 2014-11-12T13:42:40Z