topic multiple relationship in QlikView https://community.qlik.com/t5/QlikView/multiple-relationship/m-p/819337#M667569 <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></P><P><SPAN lang="en"><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>Tiers<SPAN class="atn hps">'</SPAN><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>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>Tiers<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> Tiers <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:45:20 GMT 2014-11-12T13:45:20Z multiple relationship https://community.qlik.com/t5/QlikView/multiple-relationship/m-p/819337#M667569 <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></P><P><SPAN lang="en"><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>Tiers<SPAN class="atn hps">'</SPAN><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>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>Tiers<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> Tiers <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:45:20 GMT https://community.qlik.com/t5/QlikView/multiple-relationship/m-p/819337#M667569 2014-11-12T13:45:20Z