topic Group by Issues in QlikView

Group by Issues

Wed, 02 Feb 2011 23:02:51 GMT

I keep getting the below error when I try to group the month and year from a Salesforce.com table. Can anyone tell me what is wrong with the scripting and what do I need to do to have it run correctly?

Aggregation expressions required by GROUP BY clause

Load *,
Account__c as AccountId,
Id as OrderId,
MONTH(Billing_Date__c) AS Month,
YEAR(Billing_Date__c) AS Year,
Order__c Group BY MONTH(Billing_Date__c) ,YEAR(Billing_Date__c) ;

Group by Issues

Thu, 03 Feb 2011 01:23:28 GMT

i think the Group By function comes after the From clause.

and i didn't see any From clause

Group by Issues

deepakk — Thu, 03 Feb 2011 05:10:32 GMT

hi,

what mOngkz suggested might be the reason or SInce you are using Load * its including all the fields from that table and in group by clause you are mentioning only one fields Billing_Date.

As per my understanding of Group by if we are mentioning any fields in Load statement then it either should be there after the group by clause or its should have aggregate function.

eg:

Load

Sum(Amount), Amount,

Sum(Price) as Price,

Product,

Group by Issues

Thu, 03 Feb 2011 06:24:20 GMT

Hi,

Please refer the link it will help u in group by and having clause.

http://community.qlik.com/forums/t/39103.aspx

Group by Issues

Wed, 20 Jul 2011 18:38:42 GMT

Hi,

For a group by function to work you need to things.

First:

You need an aggregation function, such as max(Date) or min(Value) or Count(Item) etc as one of the loaded field.

Second:

You will be allowed to load only those fields, based on whom you are doing the group by.

In your case, it will be just

MONTH(Billing_Date__c) ,

YEAR(Billing_Date__c)

Hope this helps,

Regards