AVERAGE QTY

[#1]

Hi,

I need to solve this:

In this table there are many  many data ( 3 year of data):

mydata:

load

posting , month(posting), year(posting) , week(posting),

gia as QTY

resudent ...

From this point I need to calculate the average QTY by every month by every year

This, for the server , is the problem  If I use the AVG()

statement  - qlikview needs many many time and memor  to finish

the operation.. Someone coulf to help me?

Thanks.

Regards

[perumal_41]

Hi

Use this Script ,get Avg Qty Month and Year wise

mydata:

load

monthname (posting) as Month_Year,

Avg(gia) as QTY

resudent Table group by monthname (posting);

Regards

Perumal A