topic Selection Question in QlikView https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327206#M583636 <HTML><HEAD></HEAD><BODY><P> You should load the Plandaten and the Istdaten in one Fakten-table and rename the similar fields (Kostenstelle, Kontonummer, Datumsfelder) to the same name.</P><P>Fakten:</P><P>load </P><P>Plan_KST as Kostenstelle,</P><P>Plan_Kontennummer as Kontennummer,</P><P>... from Plandaten;</P><P>concatenate (Fakten) load </P><P>IST_KST as Kostenstelle,</P><P>IST_Kontennummer as Kontennummer,</P><P>....</P><P>from Istdaten;</P><P>Regards</P></BODY></HTML> Tue, 11 Oct 2011 12:24:56 GMT martinpohl 2011-10-11T12:24:56Z Selection Question https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327205#M583635 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="7787" alt="Datamodel.JPG" class="jive-image-thumbnail jive-image" height="310" src="https://community.qlik.com/legacyfs/online/7787_Datamodel.JPG" width="885" /></P><P>Hi Qlikview Community,</P><P></P><P>I want the selected Fields "KST_NUMMER" and "BK_KONTENNUMMER" from different Tables to make a selection of an third Table "SAP_IST_DATEN". </P><P></P><P>If I want to connect the two left tables with a key to the right table, I get then a circular reference problem. But&nbsp; how can I make this data selection, as indicated in the screenshot ? See also the qvw file. Thank you !</P><P></P><P>Best Regards,</P></BODY></HTML> Tue, 11 Oct 2011 12:16:02 GMT https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327205#M583635 2011-10-11T12:16:02Z Selection Question https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327206#M583636 <HTML><HEAD></HEAD><BODY><P> You should load the Plandaten and the Istdaten in one Fakten-table and rename the similar fields (Kostenstelle, Kontonummer, Datumsfelder) to the same name.</P><P>Fakten:</P><P>load </P><P>Plan_KST as Kostenstelle,</P><P>Plan_Kontennummer as Kontennummer,</P><P>... from Plandaten;</P><P>concatenate (Fakten) load </P><P>IST_KST as Kostenstelle,</P><P>IST_Kontennummer as Kontennummer,</P><P>....</P><P>from Istdaten;</P><P>Regards</P></BODY></HTML> Tue, 11 Oct 2011 12:24:56 GMT https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327206#M583636 martinpohl 2011-10-11T12:24:56Z Selection Question https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327207#M583637 <HTML><HEAD></HEAD><BODY><P>On what fields are you trying to join the right table SID with BK and KST?</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Tue, 11 Oct 2011 16:27:52 GMT https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327207#M583637 2011-10-11T16:27:52Z Selection Question https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327208#M583638 <HTML><HEAD></HEAD><BODY><P>please close this thread. </P><P></P><P class="g-unit" id="gt-src-c"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">This d</SPAN><SPAN class="hps">iscussion</SPAN> <SPAN class="hps">leads to confusion. </SPAN></SPAN></P><P class="g-unit"></P><P class="g-unit"><SPAN class="short_text" lang="en"><SPAN class="hps">New Thread is generated. Thank you ! <BR /></SPAN></SPAN></P><P class="g-unit" id="gt-src-c"></P><P></P><P></P></BODY></HTML> Tue, 11 Oct 2011 23:02:14 GMT https://community.qlik.com/t5/QlikView/Selection-Question/m-p/327208#M583638 2011-10-11T23:02:14Z