Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Invalid Path

HEY I AM TRYING TO RUN THIS SCRIPT BUT I AM KEEP GETTING AN ERROR:

Inv_Sales_Temp:

LOAD

IVCOST,

IV,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

BONUSFLAG AS IVA_BONUSFLAG

FROM [lib://clinton/InvoiceItems.qvd](qvd)

WHERE IVCOST>=100000;

LEFT JOIN (Inv_Sales_Temp)

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

FROM [lib://clinton/customers.qvd](qvd)

WHERE COUNTRY ="ISRAEL"or "USA" ;

LEFT Join (Inv_Sales_Temp)

LOAD

CUST,

COST

FROM [lib://clinton/Trans.qvd]

(qvd);