Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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",
"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
FROM
(qvd);
And the error I can not get around:
Field not found - <ACTION_DT>
(qvd)
Any Ideas?
Hi,
If you used the exactly same script you posted here then check the table name you give and stored in qvd?
May be this might be the problem.
Celambarasan
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.
