Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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;

0 Replies