Group by error

[Anonymous]

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

[surendraj]

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.

[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

[surendraj]

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.