Need help in Aggregation functions

Wed, 23 Dec 2009 02:43:26 GMT

I need count the days of a customer buy our product and then sum the quantity of product in the month the customer buy to obtain the Average by day by product that this customer is buying.

And then create a Range like:

0 to 5

5 to 10

10 to 15

-.......

over 60.

and calculate how many customer by products average I have in the one of the ranges.

But in the aggregations functions on the load I have the problem that forward:

Invalid expression

Movimientos2009:

LOAD RECNO() AS INDEX,

cod_producto,

cod_cliente,

cod_sucursal,

año,

mes,

dia,

cod_fecha,

cantidad,

kilos,

dolares,

indiventa,

count(distinct dia) as diacompra,

sum(cantidad)/COUNT(DISTINCT dia) as avgsale,

vendedor

FROM

QVD\movimientos2009.qvd

(qvd)

group by cod_producto,

mes;

Need help in Aggregation functions

johnw — Wed, 23 Dec 2009 05:19:41 GMT

Every field must be either in the group by, or calculated using an aggregation.

topic Need help in Aggregation functions in QlikView

Need help in Aggregation functions

Need help in Aggregation functions