Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group By Aggregation Error

A:

LOAD ID,

     Product,

     Sales

FROM

[Left Join.xlsx]

(ooxml, embedded labels, table is Sheet1);

B:

LOAD ID,

     Margin,

     Cost

FROM

[Left Join.xlsx]

(ooxml, embedded labels, table is Sheet2);

left join(A)

load *

Resident B;

Drop table B;

//------------------------------------------------------------------------------- Code works till above------------------------

C:

LOAD Count(ID) as Counter;

LOAD ID

     Resident A

     Group By ID;    //( Error: Aggregation expression required by Group By clause. Can anybody explain this?)

1 Reply
MK_QSL
MVP
MVP

LOAD

     Count(ID) as Counter

Resident A;

No need of Group By as only single column in Load Statement.