topic Invalid expression with Min statement in QlikView

Invalid expression with Min statement

Fri, 09 Aug 2013 00:34:16 GMT

I get the following error:

Invalid expression

InvoicesAging:

LOAD "TRAIL_ID" as "AG_TRAIL_ID",

"A_ENTITY_ID" as "AG_ENTITY_ID",

"A_HEADER_ID" as "AG_HEADER_ID",

"A_ENTITY_ID"&"A_HEADER_ID" as "ENTITY_HEADER",

"STEP_NAME" as "AG_STEP_NAME",

"END_DATE" as "AG_END_DATE",

"AUDIT_STATUS" as "AG_AUDIT_STATUS",

"OUTCOME" as "AG_OUTCOME",

"CURRENT_ASSIGNEE" as "AG_CURRENT_ASSIGNEE",

Min("START_DATE") as "AG_START_DATE",

Age(Timestamp(Now()),"START_DATE") as "AGE"

Resident Audit Where Match(Len("END_DATE"),0)

Group by "TRAIL_ID","A_ENTITY_ID","A_HEADER_ID","STEP_NAME","END_DATE","AUDIT_STATUS","OUTCOME","CURRENT_ASSIGNEE"

Could any one tell me whats wrong with this ?

Thanks

Ramakanth

nagaiank — Fri, 09 Aug 2013 01:01:02 GMT

Try this.