Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Not applicable

Error message

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

Highlighted
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