Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

syntax errror

Why am I getting this error?

Field not found - <TotalCost>

ITEMLOC:

Load

VersionNum,

ItemNumLoc,

LocationNum,

DescriptionLoc,

PiecesOnHand,

TotalCost as TotalCostLoc

From q:\abauman\qlikview_qvd\youarehereab.qvd

(qvd)

and then also this error:

ODBC connection failed
ITEMLOC:
SQL SELECT *

FROM TTM.ITEMLOC

5 Replies
maneshkhottcpl
Contributor III

syntax errror

Hi,

Please explain ur issue in details. What time u r getting this error?

Not applicable

syntax errror

Thanks for your help, but i think i figured out the issue.

Thanks

Adam

pgalvezt
Valued Contributor

syntax errror

ITEMLOC:

Load

VersionNum,

ItemNumLoc,

LocationNum,

DescriptionLoc,

PiecesOnHand,

TotalCost as TotalCostLoc

From q:\abauman\qlikview_qvd\youarehereab.qvd

(qvd);

You missed the semicolon, I think. You must close each sentece or line that you've charged or created.

Make sure that the Database is in the right folder. Maybe the database was moved to another direction.

suniljain
Honored Contributor

syntax errror

if there is space between totalcost then place brackert

pgalvezt
Valued Contributor

syntax errror

ITEMLOC:

Load

VersionNum,

ItemNumLoc,

LocationNum,

DescriptionLoc,

PiecesOnHand,

TotalCost as TotalCostLoc

From q:\abauman\qlikview_qvd\youarehereab.qvd

(qvd);

You missed the semicolon, I think. You must close each sentece or line that you've charged or created.

Make sure that the Database is in the right folder. Maybe the database was moved to another direction.