Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Error message

My problem is an error message is coming up saying Field not found - <PROJECT_ID>. I don't understand why it is not found. Any help would be grateful to resolve the problem.

OP_SUMMART:

Qualify *;

unqualify PROJECT_ID;

LOAD CONTRACT as PROJECT_ID ,

COMPANY_ID,

LABOUR_NO,

PART_NO,

REAL_FINISH,

DELAY_IN_DAYS,

PCT_NOT_APPVD,

QTY_HRS_PLANNED,

QTY_HRS_ACTUAL

FROM

(qvd)

WHERE (LABOUR_NO = 'ASSY RWORK') OR

(LABOUR_NO = 'ASSY ADDS') OR

(LABOUR_NO = 'TEST MODS')

AND

(PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721' );

3 Replies
Not applicable

Error message

Because at the load time of the statement there is no PROJECT_ID field. There is a CONTRACT field. After that you can use the PROJECT_ID field.

Highlighted
Not applicable

Error message

How do i write it in the syntax to overcome the error.

Not applicable

Error message

Are you kidding? Who is writing SQL for you? Huh?

All what you need is just replace PROJECT_ID in where clause by CONTRACT.



OP_SUMMART:
Qualify *;
unqualify PROJECT_ID;
LOAD CONTRACT as PROJECT_ID ,
COMPANY_ID,
LABOUR_NO,
PART_NO,
REAL_FINISH,
DELAY_IN_DAYS,
PCT_NOT_APPVD,
QTY_HRS_PLANNED,
QTY_HRS_ACTUAL
FROM

(qvd)
WHERE (LABOUR_NO = 'ASSY RWORK') OR
(LABOUR_NO = 'ASSY ADDS') OR
(LABOUR_NO = 'TEST MODS')
AND
(CONTRACT = 'S07050720' OR CONTRACT = 'S07050721' );


Community Browser