topic Group by error in QlikView

Group by error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Group by error

surendraj — Sat, 21 Jan 2017 08:17:40 GMT

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

Re: Group by error

Gysbert_Wassenaar — Sat, 21 Jan 2017 08:28:28 GMT

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.

Re: Group by error

Anil_Babu_Samineni — Sat, 21 Jan 2017 08:33:11 GMT

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

Re: Group by error

surendraj — Sat, 21 Jan 2017 08:33:18 GMT

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.