QlikSense Scripting

Thu, 07 May 2015 16:15:59 GMT

when i am trying to use multiple joins in qlikview scripting i am getting an error as syntax (missing operator)

Fact:

LOAD `Ad_ID`,

`Cost_Element_Name` as Cost_ID,

`Cost_Source` as ExpenseSource_ID,

`Cost_Amount`,

`Prod_ID`;

SQL SELECT b.Ad_ID,

a.Cost_Element_Name,

a.Cost_Source,

a.Cost_Amount,

d.Prod_ID

FROM Input_4_Expense a

inner join Input_1_Ad b on a.Ad_ID = b.Ad_ID

inner join Input_2_AdProdCo c on c.Ad_Name = c.Ad_Name inner join Tb3_ProdCompany d

on d.Prod_Name = c.Prod_Name;

topic QlikSense Scripting in QlikView