topic Re: AGGREGATE ERROR IN SCRIPT in QlikView

AGGREGATE ERROR IN SCRIPT

Sun, 11 Oct 2015 16:11:42 GMT

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?

Re: AGGREGATE ERROR IN SCRIPT

Gysbert_Wassenaar — Sun, 11 Oct 2015 16:27:49 GMT

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

Re: AGGREGATE ERROR IN SCRIPT

sunny_talwar — Sun, 11 Oct 2015 18:46:21 GMT

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;

Re: AGGREGATE ERROR IN SCRIPT

dinuwanbr — Mon, 12 Oct 2015 06:50:01 GMT

Hi,

Can you upload sample data sheet.

Rgds,

Dinu'1