topic how to make this aggregation with sum? in QlikView

how to make this aggregation with sum?

rcandeo — Mon, 10 Feb 2014 19:32:37 GMT

Hi, I need to make a sumarization using aggregation and it´s not working for me. Anyone can help me with and example or the correct syntax?

Consider this fields:

customer

order number

amount

hours in telephone

The hours in telephone has the total time that the sales person used for this cliente in telephone, and each register has the same number.

So I need to sumarize the hours total for all customers but I need to agregate by customer, cause if I don´t do that it´ll multiply by the numbers of orders.

Thank You

Re: how to make this aggregation with sum?

jpapador — Mon, 10 Feb 2014 19:35:22 GMT

I'm not 100% sure what you are looking for but try:

Sum(Aggr(Sum(DISTINCT [Telephone Hours]), Customer))

Re: how to make this aggregation with sum?

Nicole-Smith — Mon, 10 Feb 2014 19:40:00 GMT

Maybe:

sum(total <customer> [hours in telephone])

Re: how to make this aggregation with sum?

Anonymous — Mon, 10 Feb 2014 19:54:04 GMT

How do you want to present it? If it is a chart where Customer is a dimension, the expression will be:

sum([hours in telephone])

Re: how to make this aggregation with sum?

rcandeo — Mon, 10 Feb 2014 22:18:35 GMT

That´s perfect. Thank you all for helping me.