Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

QlikSense Scripting

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;

Community Browser