Issue : Left Join in qlikview behaving as Inner Join

swapniltaz — Sat, 16 Nov 2024 01:12:03 GMT

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

Re: Issue : Left Join in qlikview behaving as Inner Join

qliksus — Tue, 25 Feb 2020 09:52:06 GMT

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

topic Issue : Left Join in qlikview behaving as Inner Join in QlikView

Issue : Left Join in qlikview behaving as Inner Join

Re: Issue : Left Join in qlikview behaving as Inner Join