how to connect 2 sheet objects

[#1]

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.

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.

Please help me out as I am unable to perform this action in qlikview.

[vardhancse]

Your requirement is not clear, what you are saying is that the selections should not pass to table box or what.?

[#3]

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.

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.

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.

[vardhancse]

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.?

If so, you can use left join(table 1) for the second table in the script level

[#5]

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?