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

Group by 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

4 Replies
surendraj
Specialist
Specialist

Hi,

Try this..it works..!!

Tab1:

LOAD ProjectID,

     ProjectName,

     ProjectType,

     ProjectManager,

     ClientID,

     Pro_Tech,

     path,

     EmployeeID

FROM

[----------------------------\PPMS_Project.qvd]

(qvd);

Trend:

Noconcatenate LOAD

   Pro_Tech ,

     path ,

     count(EmployeeID) as Count

Resident Tab1 Group by Pro_Tech, path ;

DROP Table Tab1;

--Surendra

Gysbert_Wassenaar

If you use an aggregation function like for example count, sum, max or min, then you must put all the fields that are not used in an aggregation function in a GROUP BY clause. In your case you forgot to put the field 'path' in the group by too.


talk is cheap, supply exceeds demand
Anil_Babu_Samineni

Note: While loading qvd Order by and Group by won't work in qlikview. So, you should do same thing in Resident load only

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
surendraj
Specialist
Specialist

Yes,the thumb rule for group by is

Your group by should have all the fields except the one you used for aggregation.

and

you should not apply aggrigations on your basetable(qvd).its is best practice to use resident load to apply such manipulations.