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$`;