topic Field not found error in QlikView

Field not found error

Thu, 08 Mar 2012 20:49:36 GMT

No matter what I try, I get the same error...

I've verified the .qvd is being created, and went so far as to:

copy the "Load" from the .qvd creation .qvw (1)

and use it in the .qvw (2) that is accessing the .qvd.

The Creation scripting:

.qvw (1)

Audit:

LOAD "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE";

SQL SELECT "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE"

FROM AXENT."HD_INCIDENT_AUDIT"

where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');

STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;

And the accessing of the .qvd (2) scripting

Audit:

LOAD "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE"

FROM

(qvd);

And the error I can not get around:

Field not found - <ACTION_DT>

Audit:

LOAD "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE"

FROM

(qvd)

Any Ideas?

Field not found error

CELAMBARASAN — Sat, 10 Mar 2012 05:26:32 GMT

Hi,

If you used the exactly same script you posted here then check the table name you give and stored in qvd?

Audit:

LOAD "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE";

SQL SELECT "ACTION_DT",

"AUDIT_ID",

"CHANGE_DT",

"ENTERED_BY",

"ENTRY_TYPE",

"IA_ACTION",

"INCIDENT_ID",

"NEW_VALUE",

"OLD_VALUE"

FROM AXENT."HD_INCIDENT_AUDIT"

where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');

STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;

May be this might be the problem.

Celambarasan

Field not found error

Mon, 12 Mar 2012 13:40:49 GMT

Many Thanks

I had a coworker look at the issue a day after submitting... she saw the error also.

Thanks to all that have sent a reply.