topic syntax errror in QlikView

syntax errror

Mon, 26 Jan 2026 18:19:17 GMT

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

syntax errror

maneshkhottcpl — Mon, 14 Mar 2011 13:52:59 GMT

Hi,

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

syntax errror

Mon, 14 Mar 2011 13:56:00 GMT

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

Thanks

Adam

syntax errror

pgalvezt — Mon, 14 Mar 2011 14:12:48 GMT

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.

syntax errror

suniljain — Mon, 14 Mar 2011 16:47:37 GMT

if there is space between totalcost then place brackert

syntax errror

pgalvezt — Mon, 14 Mar 2011 18:58:21 GMT

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.