Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate function invalid

I've been getting "invalid expression" errors on all my aggregation functions in a qlikview document and can't figure out why. Here are a couple examples that are not working. I can't seem to figure out where the synatx is wrong

t_AggregateReciept:

LOAD

    PO_line_key,

    sum(num(FreightCharges)) as FreightCharges

Resident t_Reciept

Group By PO_line_key;

left join(OpenOrder)

LOAD

  OrderLineKey,

  POnumber,

  POLineDueDate,

  max(POnumber) as test

Resident POLink

group by OrderLineKey;

EDIT:

Thanks for the solution. All fields must be grouped by or aggregated upon

Message was edited by: Cameron Scully

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

t_AggregateReciept:

LOAD

    PO_line_key,

    sum(num(FreightCharges)) as FreightCharges

Resident t_Reciept

Group By PO_line_key;

left join(OpenOrder)

LOAD

  OrderLineKey,

  POnumber,

  POLineDueDate,

  max(POnumber) as test

Resident POLink

group by OrderLineKey,POnumber,POLineDueDate;

View solution in original post

1 Reply
MK_QSL
MVP
MVP

t_AggregateReciept:

LOAD

    PO_line_key,

    sum(num(FreightCharges)) as FreightCharges

Resident t_Reciept

Group By PO_line_key;

left join(OpenOrder)

LOAD

  OrderLineKey,

  POnumber,

  POLineDueDate,

  max(POnumber) as test

Resident POLink

group by OrderLineKey,POnumber,POLineDueDate;