Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Group by Issues

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) ;

Tags (1)
4 Replies
Not applicable

Group by Issues

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

and i didn't see any From clause

deepakk
Valued Contributor III

Group by Issues

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,

Category

from table group by Product, Category;

Not applicable

Group by Issues

Hi,

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

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

Not applicable

Group by Issues

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