how to load different output in different tabs in qlikview

[#1]

Hi,

I have a excel sheet containing 3 tabs in it. Each has different columns. I am using the below qlikview code to load data in 2 different tabs in qlikview based on the column values in the excel sheet.
Since the excel sheet is password protected, i am using odbc connection. I want to load those values in sh01(tab1) of qlikview, based on the column trans_Status in the excel sheet. When i load value based on the below code, both sh01 and sh02 are loaded with the query output of sh02.

I am expecting sh01 to have the values if trans_status is null (based on the queries) and sho2 to have all values from excel irrespective of trans_Status. Please Help

ODBC CONNECT TO [sharetest;DBQ=C:\Qlikviewtutorial\Shares Test.xlsm] (XPassword is KCZVWUZNELaCWYIGTZMA);

//$tab SH01

SQL SELECT *

FROM ing

where tran_status is null;

SQL SELECT *

FROM ingsecond

where tran_status is null;

SQL SELECT *

FROM `ShareDetails$`

where tran_status is null;

//$tab SH02

SQL SELECT *

FROM ing;

SQL SELECT *

FROM ingsecond;

SQL SELECT *

FROM `ShareDetails$`;