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: 
Anonymous
Not applicable

Groupby error

Hi,

please give me a solution for the below error..

Trend:

Noconcatenate LOAD

   

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )Group by Pro_Tech;

it showing invalid expression ....i have attached qvd data also... urgent

2 Replies
afurtado
Partner Ambassador/MVP
Partner Ambassador/MVP

Trend:

Noconcatenate LOAD

  

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd ) Group by Pro_Tech  ,  path    ;

furtado@farolbi.com.br
Clever_Anjos
Employee
Employee

Your "Group by Section" must have all fields that are not aggregate into your LOAD section

Trend:

Noconcatenate LOAD

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

[..\RM_Extracted QVD\PROMAN\PPMS_Project.qvd]

(qvd )

Group by Pro_Tech,path;