Average in Load Resident Table not working getting invalid expression error ?

[#1]

Hi,

I am new to qlikview.

any help would b appreciated.

I am trying to do calculate Average with group by in Load Resident statement but it's not working.

I am getting invalid expression error.

Example :

TEST:

Load
OrderNumber,

AVG(Items)

Resident Test1
GROUP BY
OrderNumber;

can someone help me ?

[#2]

Can u post some sample data? What you have for items and Orderno?

[its_anandrjs]

It seems some problem in the script but it looks ok and it works perfect as you written like without aliasing it will works but check the sample file which is example same script like with your load script.

Test1:

LOAD * Inline

[

OrderNumber,Items

1,1200

2,1235

1,1235

3,1500

2,1545

3,2323

1,2456

3,4811

];

TEST:

Load

OrderNumber,

AVG(Items) as [Items Avg]

Resident Test1

GROUP BY

OrderNumber;

DROP Table Test1;

[#4]

thanks it works now.