Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
yuvaraj_g
New Contributor III

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

Tags (1)
2 Replies
MVP
MVP

Re: Groupby error

Trend:

Noconcatenate LOAD

  

     Pro_Tech ,

     path ,

     count(EmployeeID) as Count

FROM

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

(qvd ) Group by Pro_Tech  ,  path    ;

Employee
Employee

Re: Groupby error

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;