Hello ,
I am very new to Qlikview Scriptinng. I am having an issue with my script.
Data:
SQL select
Account.Account key,
Account.Account NBR,
Account.vsc key,
Accoun.Date key
Department. Department NBR,
Department.Department Date key,
Sale.sale DT Key,
Sale.sale ID,
sum(sale) as Total
vendor Account .Account key,
Vendor Account. name,
Vendor Account. CD
vendor Account.vsc key
FROM
Account,
Department,
sale,
Vendor
where Account.Datekey = Department.date key
And Sale.sale DT key = Department.deaptment date key
And account. account key = vendor account. account key,
and Account. vsc key = vendor account.vsc key
and // Date condition
group by
all the fields my the above tables.
I believe the table Account and vendor has inner join by linking the field account key(Bold lines). so, wen there is no data in vendor the account data also getting excluded.
I want the Account data even when there is no vendor data. so I need to perform left join.
Could anyone help me on this.
-Prabhu
