Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
swapniltaz
Contributor III
Contributor III

Issue : Left Join in qlikview behaving as Inner Join

 

SCRIPT   IN QLIKVIEW :

TEMP_ALL_STOCK_VOLUME_INT:
LOAD
TRD_DATE&'|'&Symbol as %Jkey ,
ACCT_MNEMONIC,
VOLUME,
NOTIONAL
FROM
[$(vQVDPath)VOLUME_DAY.QVD]
(qvd);
INNER JOIN (TEMP_ALL_STOCK_VOLUME_INT)
LOAD ACCT_MNEMONIC,
FLOWTYPE
FROM
[$(vQVDPath)TEMPFLOW_DAY.QVD]
(qvd);

NoConcatenate
TEMP_ALL_STOCK_VOLUME:
LOAD
TRD_DATE&'|'&Symbol as %Jkey ,
TRD_DATE,
Symbol ,
SECTOR,
INDUSTRY,
COUNTRY
FROM
[$(vQVDPath)TEMP_Symbol_DAY.QVD]
(qvd);
LEFT JOIN (TEMP_ALL_STOCK_VOLUME)
LOAD
%Jkey ,
ACCT_MNEMONIC,
FLOWTYPE,
CITIVOLUME,
CITINOTIONAL
RESIDENT
TEMP_ALL_STOCK_VOLUME_INT;


DROP table TEMP_ALL_STOCK_VOLUME_INT;

ISSUE : Even after doing left join I am unable to get all the symbol from the TEMP_Symbol_DAY.QVD file its just returning the records for which we have  value in  TEMP_ALL_STOCK_VOLUME_INT

Can someone please help what is wrong here 

 

Labels (1)
1 Reply
qliksus
Specialist II
Specialist II

The script has noting to filter data from TEMP_Symbol_DAY.QVD . Can you attach a sample file ?