topic Re: how to connect 2 sheet  objects in QlikView https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890707#M995140 <HTML><HEAD></HEAD><BODY><P>Thanks Sasi! just to clarify with you, i will have to export the rows from 1st table to a script and then reload the second table accordingly.am i right?</P></BODY></HTML> Thu, 25 Jun 2015 06:13:25 GMT 2015-06-25T06:13:25Z how to connect 2 sheet objects https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890703#M995136 <HTML><HEAD></HEAD><BODY><P>i have a straight table which performs calculations like cumulative sales, cumulative percentage on companyId. I want all the company ID's displayed in the first table to load in a table box with all columns information from the source data. I am unable to link the straight table to the table box so that when the straight table is loaded, corresponding ID should be loaded in the table box.</P><P></P><P>when I select 1 row in straight table, the corresponding ID are filtered in the table box but I need it filter on all rows in the straight table.</P><P></P><P>Please help me out as I am unable to perform this action in qlikview.</P></BODY></HTML> Wed, 24 Jun 2015 10:36:06 GMT https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890703#M995136 2015-06-24T10:36:06Z Re: how to connect 2 sheet objects https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890704#M995137 <HTML><HEAD></HEAD><BODY><P>Your requirement is not clear, what you are saying is that the selections should not pass to table box or what.?</P></BODY></HTML> Wed, 24 Jun 2015 11:16:18 GMT https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890704#M995137 vardhancse 2015-06-24T11:16:18Z Re: how to connect 2 sheet  objects https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890705#M995138 <HTML><HEAD></HEAD><BODY><P>ok..I will explain in detail.. I have data in which there are many transactions for a companyID. I have shortlisted a few companyID's based on the calculations in the straight table and loading those companyID's with calculated expressions.</P><P></P><P>i need to load a new corresponding straight table/table box in which only those rows should be loaded whose ID is loaded in the initial straight table as well.</P><P></P><P>the complete data should not be loaded in the second straight table/ table box. without the selecting anything in the initial straight table, corresponding data is to be loaded in the new straight table or table box.</P></BODY></HTML> Wed, 24 Jun 2015 11:28:22 GMT https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890705#M995138 2015-06-24T11:28:22Z Re: how to connect 2 sheet  objects https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890706#M995139 <HTML><HEAD></HEAD><BODY><P>So what I understood was, what ever data you loaded first, that only related data need to be loaded from second table..is that correct.?</P><P></P><P>If so, you can use left join(table 1) for the second table in the script level</P></BODY></HTML> Thu, 25 Jun 2015 04:45:26 GMT https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890706#M995139 vardhancse 2015-06-25T04:45:26Z Re: how to connect 2 sheet  objects https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890707#M995140 <HTML><HEAD></HEAD><BODY><P>Thanks Sasi! just to clarify with you, i will have to export the rows from 1st table to a script and then reload the second table accordingly.am i right?</P></BODY></HTML> Thu, 25 Jun 2015 06:13:25 GMT https://community.qlik.com/t5/QlikView/how-to-connect-2-sheet-objects/m-p/890707#M995140 2015-06-25T06:13:25Z