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: 
Not applicable

AGGREGATE ERROR IN SCRIPT

CLAIMS_REPORT_DEC:

LOAD

  AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,

   Count (DISTINCT CLAIM_NO) as Count_Claims

  

FROM

$(V_Layer1_QVD)\CLAIMS_REPORT.qvd

(qvd)

where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'

Group by  AS_OF  ;

Attached is the error  I am getting. What am I doing wrong here?

3 Replies
Gysbert_Wassenaar

You will have to add CLAIM_NO to the group by clause as well.


talk is cheap, supply exceeds demand
sunny_talwar

May be this:

CLAIMS_REPORT_DEC:

LOAD

  AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,

   Count (DISTINCT CLAIM_NO) as Count_Claims

FROM

$(V_Layer1_QVD)\CLAIMS_REPORT.qvd

(qvd)

where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'

Group By  AS_OF & '|'  & CLAIM_NO;

dinuwanbr
Creator III
Creator III

Hi,

Can you upload sample data sheet.

Rgds,

Dinu'1